OLEObject GetFocus

E

Erich Neuwirth

Is there anywhere an example how I can make an OLEObject created
programmatically to react to its GotFocus event?
I do not manage to do that.
 
C

Chip Pearson

What type of object are you dealing with? The following works for
me.

Private Sub TextBox1_GotFocus()
MsgBox "Got Focus"
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
E

Erich Neuwirth

In have a sheet with TextBox1
on the sheet and your code in a class module.
this does NOT work.

Should I add TextBox1 with ActiveSheet.OLEObjects.Add
in the class module?
 
Top