Help with getting data from a worksheet

[BogN]

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,

[Matt Lunn]

"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?