Goto a control element

[Guest]

I want to include a line in my VBA macro that will select a combo box, but I
don't know how to address it to put it into focus.

Can I name it? Or is there another way to handle it. An example would be
very much appreciated.

 

[Tom Ogilvy]

Where is the combobox located. Worksheet, userform, dialogsheet

control toolbox toolbar combobox or one from the forms toolbar. If from the
data validation option, then just select the cell.

 

[Guest]

The combo box is located on a worksheet - and is an element selected from the
toolbar.

 

[Tom Ogilvy]

Activesheet.Combobox1.Activate

or

activesheet.OleObjects("Combobox1").Activate

 

[Guest]

Appreciate this help, Tom. Thank you.

Can you tell me how to identify the object names (like Combobox1)

 

[Dave Peterson]

Try selecting it (in design mode--another icon on that control toolbox toolbar).

Then look at the namebox (to the left of the formulabar).