Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select or Enter into a TextBox on a UserForm
I am designing a Login Userform. If the user enters the wrong password I
want to delete the text they entered and then have the textbox selected so they can begin typing automatically. Any suggestions would be great! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select or Enter into a TextBox on a UserForm
If TextBox1.Text < "password" Then
MsgBox "Invalid Password", vbCritical TextBox1.SetFocus TextBox1 = "" End If -- Dan On Jan 3, 1:57*pm, RyanH wrote: I am designing a Login Userform. *If the user enters the wrong password I want to delete the text they entered and then have the textbox selected so they can begin typing automatically. *Any suggestions would be great! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select or Enter into a TextBox on a UserForm
Ahhhhhh. Stupid me, I had this:
If TextBox1.Text < "password" Then MsgBox "Invalid Password", vbCritical TextBox1 = "" TextBox1.SetFocus End If all I had to do is switch SetFocus and "" Thanks for the help and the quick response "Dan R." wrote: If TextBox1.Text < "password" Then MsgBox "Invalid Password", vbCritical TextBox1.SetFocus TextBox1 = "" End If -- Dan On Jan 3, 1:57 pm, RyanH wrote: I am designing a Login Userform. If the user enters the wrong password I want to delete the text they entered and then have the textbox selected so they can begin typing automatically. Any suggestions would be great! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform: Enter combobox value unless textbox contains data | Excel Programming | |||
Userform - Move to next textbox field by hitting enter instead of | Excel Programming | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |