Set Focus to Embedded Control
How can you set the focus to a control embedded on an Excel sheet?
An embedded control does not have a .SetFocus method, and the .Select method selects the control as if in design mode with sizing handles etc. .Activate is useless.
Why do I want to know? I'm trying to simulate focus change when the user presses Tab in an embedded control as if the embedded controls were in a form. I can determine that tab was pressed by examining the KeyCode in the KeyDown event, but then what? :confused:
Thanks!