All I need is input box "Equipment Used" to loop until anything is input. This can be letters or numbers or any combination.
Please Login or Register to view this content.
All I need is input box "Equipment Used" to loop until anything is input. This can be letters or numbers or any combination.
Please Login or Register to view this content.
I wouldn't use loop. But error handle in those case. Also instead of InputBox, use Application.InputBox (which can force specific type of data).
Something like...
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
I should mention I'm not very proficient with coding. It works perfectly except for the R variable doesn't loop back. All I need is a way for it to require input into "equipment used".
I appreciate your help, but don't really need anything other then for it to loop until a value is input into that box. Just like the IsNumeric loop.
I really don't want to start over, and I don't understand how to apply your code
Then use Until Len(R) > 0?
Oh and in previous code, I forgot to check Len(R).
So amended code would be.
Please Login or Register to view this content.
Last edited by CK76; 08-11-2017 at 11:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks