View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rob Flott Rob Flott is offline
external usenet poster
 
Posts: 10
Default How to set focus on an ActiveX ListBox

On Jun 21, 6:07*pm, isabelle wrote:
Rob, you're welcome! ..feedback is always appreciated, thank to you!

--
isabelle

Le 2012-06-21 18:08, Rob Flott a écrit :





Isabelle, thank you very much...this works great...- Hide quoted text -


- Show quoted text -


Hi Isabelle....I spoke to soon...when I run the macro it works
fine...but when I 'call' the macro in my 'Workbook_Open()' sub I get
'Run-Time error '438' Object doesn't support this property or
method'. Ironically, when I click 'End' on this error message it runs
the macro without any problems. Any ideas as to why this happens?

Thanks Isabelle