Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto a control element
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto a control element
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto a control element
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto a control element
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto a control element
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto a control element
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage of an Element ... | New Users to Excel | |||
How to define the 1st, 2nd and 3rd element | Excel Worksheet Functions | |||
On Error Goto doesn't goto | Excel Programming | |||
On Error Goto doesn't goto | Excel Programming | |||
control element | Excel Programming |