![]() |
validation - error mismatch
Hi Here's my problem I wrote a code to enter automatically the current date in a number of rows (1 to 8), through an inputbox I have a number of code lines to prevent typing wrong values (kind of home made validation) I've declared num_linhas (the number of lines I want the date to be inserted in) as variant and the procedure runs only if the input is a number (isnumeric function). however, the code doesn't work if I type 5, it only inserts the date in one line. If the variable is declared as integer, it works fine but if, by mistake, text is inserted, i get a type mismatch error... thank you -- pmguerra ------------------------------------------------------------------------ pmguerra's Profile: http://www.excelforum.com/member.php...o&userid=14986 View this thread: http://www.excelforum.com/showthread...hreadid=503301 |
All times are GMT +1. The time now is 10:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com