LinkBack URL
About LinkBacks
Hi
If I want the user to only enter a percentage into an input box what is the best way to do this.
Kind regards
Keith
Input Box Valdation
Hi
If I want the user to only enter a percentage into an input box what is the best way to do this.
Kind regards
Keith
In what format will it be entered?
As a number followed by %
just as a number without the %
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
thanks
as a number followed by a %
You will need to test for several different entries
In the above code a space between the number & the % symbol will test as a valid entry. A space anywhere else will not pass the test
Please Login or Register to view this content.
If you want to test for a space between the number & the % then also use
before the End With commandPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks