Thread: Calling an embedded items event procedure from within a normal module
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Calling an embedded items event procedure from within a normal module
The following code works for me just fine in Excel 2003.

Private Sub TextBox1_GotFocus()
MsgBox "GotFocus"
End Sub

What specific error are you seeing?


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




"jase" wrote in message
oups.com...
Trying to call the event procedure "Private Sub
TxtString_GotFocus()"
from with a normal module in the same workbook.

The event procedure is for a textbox that is embedded in Sheet4
so the
event procedure is within the class module connected to Sheet4

Must be quite easy, but keeps throwing an error for me

Help greatly appreciated
Jason



Reply With QuoteReply With Quote