Can´t set focus on OleObjects ComboBox

R

RCL

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 !
 
B

Bob Phillips

ActiveSheet.OLEObjects("CBoxConc").activate

--

HTH

Bob Phillips

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

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 !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make scroll bar permanently visible, Word 365 0
How to set focus on an ActiveX ListBox 7
Ole Object Problems 2
Bugs in Office 2019 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Type Mismatch error when trying to generically set ComboBox to aComboBox variable 8
Iterating through a ComboBox's values 6
OLEObjects - Paste combobox contents to a sheet 4

Top