"barrfly" wrote:


I have called data from another tab with a combo box by doing the
following:

First - name the range of the data on the other tab. This can be done
with the shortcut on the toolbar (left of the formula bar) or by going
to Insert - Name - Define
next - in the combobox where it asks for the input range, enter
"=namedrange"

Hope this helps.


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=392336



If you have a combo box in a userform how do you reference a named range
from worksheet? I wanted to do this and then make something that lets me
select option "Other", ask user what should be in there and then append it to
the list.