Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

More questions on comboboxes

  Asked By: Cameron    Date: Jan 14    Category: MS Office    Views: 621
  

In Visual Basic windows form you can assign a data source to a
control. In Excel can you bind a range to an ActiveX control combobox
If I had to write code to add items from a range to the combobox is
there a spreadsheet load like a VB form load. Putting the code in the
form activate doesn't seem to do anything.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Zoar Mizrachi     Answered On: Jan 14

The events you could use would include

Workbook Open
Workbook Activate
Worksheet Activate
Userform Activate
Userform Initialize

I would suggest you also look at the VBE help item "Initializing Control
Properties"

You can set the Rowsource property of a combobox  to a range  in a worksheet and
you do not need to initialise it.

 
Didn't find what you were looking for? Find more on More questions on comboboxes Or get search suggestion and latest updates.




Tagged: