Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 137
Default Userform conditional fields

Hi,

Can someone please help me? I want to create a userform where textbox2 is invisible unless textbox1 = "New".

TIA


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validating Required Fields in Userform robinsn Excel Discussion (Misc queries) 0 July 24th 10 02:16 PM
Conditional formatting and userform jknapp1005 Excel Discussion (Misc queries) 0 May 6th 09 04:53 PM
Help Counting Conditional Text Fields Rodman Excel Discussion (Misc queries) 2 January 25th 07 09:40 PM
Conditional Fields DaveCPA Excel Discussion (Misc queries) 0 September 21st 05 10:37 PM
Conditional Checkbox Creation on a UserForm Todd Huttenstine[_2_] Excel Programming 1 November 21st 03 03:38 PM


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"