to textbox
 

Hi all,

I want locate cursor (on focus) in textbox1 (in sheet1)
when i open workbook.
Is there any code?

Regards
Mark

to textbox
 

Assuming a textbox from the control toolbox toolbar:

Private Sub Workbook_Open()
With ThisWorkbook.Worksheets("sheet1")
.Activate
.TextBox1.Activate
End With

End Sub

Put this in the ThisWorkbook code module.

--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
Hi all,

I want locate cursor (on focus) in textbox1 (in sheet1)
when i open workbook.
Is there any code?

Regards
Mark

to textbox
 

Hi Tom!

It's work. I wrote similar code, your and me code after
open workbook activate texbox and I can write in textbox
but at start i don't see it.. :) It has introduced me to
error.

Thanks
Mark

-----Original Message-----
Assuming a textbox from the control toolbox toolbar:

Private Sub Workbook_Open()
With ThisWorkbook.Worksheets("sheet1")
.Activate
.TextBox1.Activate
End With

End Sub

Put this in the ThisWorkbook code module.

--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
Hi all,

I want locate cursor (on focus) in textbox1 (in sheet1)
when i open workbook.
Is there any code?

Regards
Mark


.