"BogN" wrote:


Hi,

I have 2 excel sheets

username sheet
---------------
it contains just usernames in one column

main sheet
-----------
i want to chose from a listbox, combobox, or whatever one or more
usernames
from the username sheet.

How can i do that??

another question:
I want to be sure that every username has one instance only


can you help be?

BogN,


--
BogN
------------------------------------------------------------------------
BogN's Profile: http://www.excelforum.com/member.php...o&userid=34979
View this thread: http://www.excelforum.com/showthread...hreadid=547173



Create a named range for your username list and then set the ListFillRange
property of the control to the name you just defined.

The removal of duplicates can only be done by modifying your list as there
is no setting to do this in the control. Does the username list change?