Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel UserForm Listbox RowSource 1

Status
Not open for further replies.

jslmvl

Vendor
Jan 26, 2008
268
GB
Hi,

I want to follow this Excel UserForm example:
("Click the ListBox and scroll to RowSource in the Properties window. Click in the right section of RowSource and type "sheet1!b1:b4" (without the quotation marks)."

What I did was:
In Excel (I don't know what version it is)
Alt-F11
Inserted UserFome1
Toolbox
Aditional Controls
Listbox DTC
added Listbox1 on UserForm1

However, in Listbox1's Properties window, I couldn't find "RowSource"

Can you point which step I was doing wrong?
 
Normally there is no need to add additional controls. The listbox should be already in the toolbox. After 'Aditional Controls' 'Microsoft Forms 2.0 ListBox' should be checked.

combo
 
Thanks a lot.
Yes, it should be Forms 2.0 ListBox!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top