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