Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox validation with 3 conditions
Mr.Rick Rothstein gave me correct vb code for testing two textbox for
(equal)values. How to codify the following logic with Greater than or less than parameter I have 2 text boxes viz.TextBox1 and Textbox2 in a userform.TextBox1 has a archival value from a worksheet source. Condition1:The Textbox2 can be left blank without entering any data/value.condition2:But if entry is needed only numeric values(numbers with or without decimals) be entered, condition3:and the TextBox2 value should not be greater than TextBox1. cursor should not move from the textbox until correction/rectification done by user. While rectification if user deletes whole entry and leave the textbox blank, or corrects the entry by putting exact values as in TextBox1. -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox validation | Excel Programming | |||
textbox validation | Excel Programming | |||
textbox value validation | Excel Programming | |||
Textbox validation | Excel Programming | |||
textbox validation | Excel Programming |