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.

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.

--
Regards,
Tom Ogilvy

"dsimcox" wrote in message
...
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.

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

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy

"dsimcox" wrote in message
...
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.

Activesheet.Combobox1.Activate

or

activesheet.OleObjects("Combobox1").Activate

--
Regards,
Tom Ogilvy


"dsimcox" wrote in message
...
The combo box is located on a worksheet - and is an element selected from
the
toolbar.

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy

"dsimcox" wrote in message
...
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.

Appreciate this help, Tom. Thank you.

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

"Tom Ogilvy" wrote:

Activesheet.Combobox1.Activate

or

activesheet.OleObjects("Combobox1").Activate

--
Regards,
Tom Ogilvy


"dsimcox" wrote in message
...
The combo box is located on a worksheet - and is an element selected from
the
toolbar.

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy

"dsimcox" wrote in message
...
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.

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

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



dsimcox wrote:

Appreciate this help, Tom. Thank you.

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

"Tom Ogilvy" wrote:

Activesheet.Combobox1.Activate

or

activesheet.OleObjects("Combobox1").Activate

--
Regards,
Tom Ogilvy


"dsimcox" wrote in message
...
The combo box is located on a worksheet - and is an element selected from
the
toolbar.

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy

"dsimcox" wrote in message
...
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.









--

Dave Peterson