to textbox

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi all,

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

Regards
Mark
 
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.
 
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
 
Back
Top