Can´t set focus on OleObjects ComboBox
 

Hi, I have inserted a ComboBox in my Excel sheet.

But I can´t set focus on it with this code:
ActiveSheet.OLEObjects("CBoxConc").object.SetFocus

Do you know how to set focus to a ComboBox inserted inside an Excel
sheet?

Thanks for the help !

Can´t set focus on OleObjects ComboBox
 

ActiveSheet.OLEObjects("CBoxConc").activate

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"RCL" wrote in message
ups.com...
Hi, I have inserted a ComboBox in my Excel sheet.

But I can´t set focus on it with this code:
ActiveSheet.OLEObjects("CBoxConc").object.SetFocus

Do you know how to set focus to a ComboBox inserted inside an Excel
sheet?

Thanks for the help !