Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Vba - Text Box active by default
Hi all,
I am using a user for which contains two text boxes. I want TextBox2 being my default option when userform activates. I need to show the cursor into TextBox2 and ready to input data. Could anyone help, please? Thanks in advance, Aldo -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Vba - Text Box active by default
Hi ALdo
In the userform module: Private Sub UserForm_Initialize() TextBox2.SetFocus End Sub HTH. Best wishes Harald "ajliaks " skrev i melding ... Hi all, I am using a user for which contains two text boxes. I want TextBox2 being my default option when userform activates. I need to show the cursor into TextBox2 and ready to input data. Could anyone help, please? Thanks in advance, Aldo. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Vba - Text Box active by default
If by activate, you mean when the userform is first shown (created), then set the tabindex property to 0 If hiding and showing again, then see Harald's post (which should work in the above as well, but setting the tabindex should also be done). -- Regards, Tom Ogilvy "ajliaks " wrote in message ... Hi all, I am using a user for which contains two text boxes. I want TextBox2 being my default option when userform activates. I need to show the cursor into TextBox2 and ready to input data. Could anyone help, please? Thanks in advance, Aldo. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default font for pasted text in text boxes - Excel 2007 | Excel Discussion (Misc queries) | |||
Active cell default colour | Excel Discussion (Misc queries) | |||
How to set printer default to select active sheet not whole book | Excel Discussion (Misc queries) | |||
Excel 2007 - Text Box (Active X) title | Excel Discussion (Misc queries) | |||
CHANGE DEFAULT PRINT TO SELECTION INSTEAD OF ACTIVE WORKSHEET | New Users to Excel |