PDA

View Full Version : Combo Box - How???



maxhayden
09-09-2009, 10:43 AM
Hi guys,

I'm relatively new to user forms and combo boxs.

I have a row with 20 different user names in.

I have a userform - and a combo box.

I would like to have the usernames come up in the combo box.

The range is B6:U6

I'm sure this is fairly easy, but I have no idea?


Pls help.

Thanks in advance

nst1107
09-09-2009, 11:26 AM
You can do this either programmatically or in design. Set the RowSource property of the combobox = YourSheet!B6:U6 and the ColumnCount = 20. If you're setting the RowSource programmatically, remember that the property is a string, not a range.

lucas
09-09-2009, 11:51 AM
This would be even easier if you transpose the usernames to be in one column instead of 20....

maxhayden
09-09-2009, 01:07 PM
Thanks for that... I'm really close. I'm going for it in design stage, but I can't get the sheet name right.

The sheet name is ("User Quality Analysis") - so how do I get that in there?

= Sheets("User Quality Analysis")..?...A1:A20

p45cal
09-09-2009, 01:21 PM
'User Quality Analysis'!A1:A20

maxhayden
09-09-2009, 01:32 PM
Thanks...I was trying it with "xxx" and not 'xxx' what an r-tard