Help - GotFocus and Lost focus Event

Hi! can anybody pls. help me..I have an excel file with macro using VB6...my excel file has a button, where in when i click it a form will appear containing 2 textboxs and 1 button and i want my textbox to change color when it "GotFocus" and "lostFocus" but unfurtunetly the GotFucos Event and LostFOcus event is not in the list. can anybody pls. help me on this...thanks in advance!

Hi daimous,

First off, your message will probably be moved to "Office Development".

But anyway, what version are you using. I have Excel 2002. And it has the events.

VB Code:

Private Sub TextBox1_GotFocus()
 
End Sub
 
 
Private Sub TextBox1_LostFocus()
 
End Sub

why? my question is something to do with VB6...anyway..im using office 2003..i just dont know why i dont have the gotfucos and lostfocus events...

This isn't VB6, but VBA6.X (Visual Basic for Applications), which uses similar code, but is different - especially in cases like this. As such I have moved this thread to the Office Development forum, where you should get more relevant answers.

ok thanks!!!!