input check in cell question
Hi experts,
I have an application that runs throug ha userform. a button brings the user to an excel sheet("data") where the user has to put in: - in column b (B7:B1000) a date using the following format dd-mm-yyyy - in column c (C7:C1000) a number where a . is used for seperating thousands and not used as a comma - in column c (D7:D1000) a percentage (like 50 but NOT 50%) On the sheet there is a button to go back to the userform. is there code to check if the input is according to what i want before going back to the userform... Thanks, Pierre -- Message posted via http://www.officekb.com |
All times are GMT +1. The time now is 04:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com