My form gets a stock number from the user. The number must be 6 digits only. How can I validate that the input is exactly that? The value can be anything from 000001 through 999999.
Thanks for your input!
My form gets a stock number from the user. The number must be 6 digits only. How can I validate that the input is exactly that? The value can be anything from 000001 through 999999.
Thanks for your input!
Hello snapfade,
Is this stock number input on a worksheet?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I'm fairly new to VBA but maybe I can steer you in the right direction...
Maybe...
Please Login or Register to view this content.
Last edited by Leith Ross; 11-22-2013 at 05:26 PM. Reason: Added Code Tagas
Try something like this...
If TextBox1.Value Like "######" Then
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi Leith,
Thanks for your input.
The input is from a form and the result will be put into a worksheet.
Hi AlphaFrog,
Thanks for your input. The solution is perfect!
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks