Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |