ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   validation - error mismatch (https://www.excelbanter.com/excel-programming/351001-validation-error-mismatch.html)

pmguerra[_2_]

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