inputbox that accepts numbers

[bbrazeau]

Is there an "Inputbox" type function that accepts integers. I want the user to input a number and use it in VBA code.

[boblarson]

You can use the InputBox for numbers. What is the code you want to use it in? You can use something like:

Dim intX As Integer
 
 
intX = Val(InputBox("Enter Number"))

[bbrazeau]

Hi Bob, Thank you. That works, and is simple to impliment.