Hi Aiyer,

Try:

mynum = Application.InputBox _
("Enter the area multiplication factor", Type:=1)



---
Regards,
Norman



"aiyer " wrote in message
...
Hi all!

An input boxprompts the user to specify a numeric value for a certain
variable "mynum", as follows. The user CANNOT type in
gibberish/characters. It has to be only numbers -ve.0. + ve numbers
only are acceptable.

==============================================
mynum = InputBox("Enter the area multiplication factor")

If mynum = " " Then
Exit Sub
End If
==============================================

But the above logic accepts characer inputs/gibberish as well.
Look forward to your helps guys.

Thanks alot,

Arun...
Vtec. Corp.


---
Message posted from http://www.ExcelForum.com/