Hi,
I have a combobox in the userform. And I have a data range: (A2:A40).
I want the dropdown to read the range A2:A40.
That will help the user choose from the dropown list.
Now what if the range gets smaller or larger. Do I have to change the
"Row Source" Everytime a change takes place?
I mean A40 is the destination, but it might be less in the future so
how do I
fix: A2:A40 once and for all.
Thanks,
Nawaf
--
countryfan_nt
------------------------------------------------------------------------
countryfan_nt's Profile:
http://www.excelforum.com/member.php...o&userid=11051
View this thread:
http://www.excelforum.com/showthread...hreadid=386366