Input box cancel button

[vaughn9]

When I click on cancel from my input box I am getting an error messagae. What can Iadd to the code below that would make my cancel button not give me an error message.

Code

dim amtmoney as currency

amtmoney= InputBox("Enter amount of money", "Money", "$&quot

Form2.Text2 = FormatCurrency(Val(amtmoney))

 

[johnwm]

You've dimmed amtmoney as Currency - inputBox returns a string. Use a string variable to get the returned value, then do your conversion

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'