Hello, I am trying to make form so that users can input numbers and text
in a spreadsheet via a form. I have got the following code but the
problem with it is that each question opens in a seperate box. I would
also like a drop down box on the last one to allow them to choose
between discount 1, discount 2 or discount 3. Is there any way to have
each of thos represent a number, so that the user just types in
discount one and a number ie 17.5 appears in the cell instead.

UserVal = Application.InputBox(prompt:="Enter Sale Price", Type:=1)
If UserVal < False Then Range("C25") = UserVal
UserVal = Application.InputBox(prompt:="Enter Quantity", Type:=1)
If UserVal < False Then Range("C27") = UserVal
UserVal = Application.InputBox(prompt:="Enter Discount Rate")
If UserVal < False Then Range("C31") = UserVal

Thanks for your help, Jon

p.s I've only just started using vba so i'm not very good at it at the
moment.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/