Hello,
I have a ComboBox userform, which reads the values from the RowSource.
I want the CombBox to display, by default, the first item of the RowSource;
Right now I am getting a blank option in the ComboBox dropdown so I need to click on it and select what I need, but I would like to have the first item by default, in the ComboBox.
Could you please advise, how to do this?
Thanks
This is the only way I know how to do it-
Select the combobox on the userform
In the bottom left pane (the one for combobox properties) click in the blank field next to Value
Type in whatever is the first item in your list.
There is probably a better way to do it, I just don't know how.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Told you there was a better way to do it.
Thanks AlphaFrog
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks