Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Form Validation in VB
EDIT: I've just typed this out and fixed the problem for myself. I knew it was simple - the validate form needs to be called when the "textbox1_change" & "textbox2_change" routines are run. I thought I would post it anyway for any other newbies who want to make a simple form validate - as I could'nt locate a similar post on the forum. Cheers s --------------- Hi all, Sorry to post again - but once again I have hit a brick wall and can't find the answers I need! :( Hopefully someone can help me - I am trying to write a form validation, which disables a button unless two text fields have information in them. I think the answer is simple. Here is my code so far - -Private Sub Userform_Initialize() CommandButton1.Enabled = False TextBox1.Value = "" TextBox2.Value = "" With ComboBox1 ..AddItem "Team 1" ..AddItem "Team 2" ..AddItem "Team 3" ..AddItem "Team 4" End With Call userform_validate End Sub- -Private Sub userform_validate() CommandButton1.Enabled = False If TextBox1.Value < "" And TextBox2.Value < "" Then CommandButton1.Enabled = True End If End Sub- As you guys can see by my code, I'm a complete noob! I think in theory the code is ok - but from what I can see the problem is with where the code is placed. Thanks -- systematic ------------------------------------------------------------------------ systematic's Profile: http://www.excelforum.com/member.php...o&userid=25294 View this thread: http://www.excelforum.com/showthread...hreadid=388330 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation list in data entry form | Excel Discussion (Misc queries) | |||
Data validation causing problems when using a data form in Excel 2 | Excel Worksheet Functions | |||
how do I add data validation dropdown lists to a Form | Excel Worksheet Functions | |||
Web form validation using Excel datasource? | Excel Programming | |||
Trapping and preventing a form from being e-mailed before validation | Excel Programming |