Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform conditional fields
Hi,
Can someone please help me? I want to create a userform where textbox2 is invisible unless textbox1 = "New". TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform conditional fields
Hi
Set Visible property of Textbox2 to False and place this into the userform's code: Private Sub UserForm_Initialize() Me.TextBox2.Visible = False End Sub Private Sub TextBox1_Change() If TextBox1 = "New" Then Me.TextBox2.Visible = True End Sub HTH Cordially Pascal "Newbie" a écrit dans le message de ... Hi, Can someone please help me? I want to create a userform where textbox2 is invisible unless textbox1 = "New". TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform conditional fields
TextBox2.Visible = (Textbox1.Text="New")
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Newbie" wrote in message ... Hi, Can someone please help me? I want to create a userform where textbox2 is invisible unless textbox1 = "New". TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validating Required Fields in Userform | Excel Discussion (Misc queries) | |||
Conditional formatting and userform | Excel Discussion (Misc queries) | |||
Help Counting Conditional Text Fields | Excel Discussion (Misc queries) | |||
Conditional Fields | Excel Discussion (Misc queries) | |||
Conditional Checkbox Creation on a UserForm | Excel Programming |