Help with getting data from a worksheet
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 |
Help with getting data from a worksheet
"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? |
All times are GMT +1. The time now is 02:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com