TextBox Validation in Excel VBA
Posted on 2011-03-03
I have three TextBoxes in my Excel VBA application, i need to perform the below validations
if there is value in first textbox then it should be assigned to a variable say X
If only there is value in first textbox , it should check for second textbox and assign the values to X and Y variables respectively
If no value in first textbox then shouldn't go for second textbox validation at all, instead to third textbox directly from first.
Can anyone write the IF ....Then loop with the above validations