combobox row source

[Quicksnot]

Hi all

with a combobox in VBA I use range for row source, but how do I use combobox, to list a1,b1,c1, etc

probably something simple, or it can't be done lol..

Please help
Thanks
Keith

[mancubus]

hi.

try

Please Login or Register  to view this content.

[G e r a r d]

Hello Keith

• Is the combobox on a sheet or in a form?
• Do you want to enter the contens of cel A1, B1, etc. or just the text "a1", "b1", etc.

For a combobox named ComboBox1 on sheet1 you can load the contens of Cel A1 ..... into the Combobox when the workbook is opened.

In this workbook:

Please Login or Register  to view this content.

Gr,
Gerard

[Quicksnot]

Hi G e r a r d

•Is the combobox on a sheet or in a form? yes its on a VBA form, combobox7
•Do you want to enter the contens of cel A1, B1, etc. or just the text "a1", "b1", etc. just the text 1,2,3 etc

Hi mancubus

I altered the addtenms to the cells that have the numbers in, but nothing shows up when I look into the combobox7

Thanks for your rapid responses

Keith

[G e r a r d]

Hi Keith,

You better set items during initializing of form:

Please Login or Register  to view this content.

gr.
Gerard

[mancubus]

hi Quicksnot.

Gerard has already replied that. put the code in UserForm's Initialize Event.

BTW, if items are cell references rather than strings then use .AddItem Range("F1").Value, etc.

[Quicksnot]

lol sorry guys forgot how to mark solved

Keith

[G e r a r d]

-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved