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: 576

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.



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

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.