Re: Dynamic input range

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

ahh - for that (as far as i know - i could be wrong) you would have to use
code in order to get the 'source' to display in the combo box

however, you can still use the method i described to keep your range up to
date.

something like

combobox1.clear
for each c in Range("MyNamedRange")
combobox.additem(c)
next
combobox.listindex=0

would put each cell that is in MyNamedRange as an element in combobox1

if anyone else has suggestions or solution, i'd like to learn too =)

hth

J
"Roman" wrote:

> Actually I mean the one from forms toolBAR!
>
>
.

Relevant Pages