LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 65
Default Data Validation for % input in userfom

hi - I have a user entry text box to enter a % value...and a submit command
button which mutiplies the entry with another number. i'm able to take inputs
both as % and as whole numbers and based on the input..either remove the % or
if whole number then divide by 100. i would like to put a change event which
catches any input other than numers or %....valid entries would be 100% or
100.....need help with being able to catch entries like rree or rr%

any help much appreciated.

regards,
Amit
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Input Validation Mark S[_2_] Excel Discussion (Misc queries) 5 February 24th 08 12:00 AM
Input Box data validation Mathew Excel Programming 7 September 6th 07 08:09 PM
Data Validation list in Input Box... Possible ? Corey Excel Programming 5 June 28th 06 08:00 AM
DataValidationInput message irresistible007 Excel Worksheet Functions 1 December 3rd 05 01:06 PM
Data Validation with additional input Shane73 Excel Programming 2 October 17th 05 06:59 AM


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"