Selecting/Activating Control Tools Combobox on Sheet
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
for each oleObj on Activesheet.OleObjects
if oleObj.TopLeftCell.Address = Target.Address then
if typeof oleObj.Object is MSForms.Combobox then
oleObj.Object.DropDown
exit for
end if
end if
Next
End Sub
--
Regards,
Tom Ogilvy
"steve" wrote in message
...
Working Excel97 SR2
I have a sheet with a number of comboboxes. When I enter a cell
containing
a combobox I want to activate the combobox and do a
Combobox1.Dropdown
At present I am using event code for each cell but would like to write
generic code to identify the combobox in the cell. (I could use a
secondary
column to contain the the combobox #)
Can anyone suggest code that could do something like
Comboboxx.Dropdown
Thanks in advance...
--
sb
|