How can I have excel prompt the user to input data. I want to have the user to be prompted for 3-4 question then it creates a answer depending on the calculations in excel. This message was edited by Shaners on 2002-08-30 09:00
Dim Message, Title, Default, MyValue
Message = "Enter a value between 1 and 3" ' Set prompt.
Title = "InputBox Demo" ' Set title.
Default = "1" ' Set default.
' Display message, title, and default value.
MyValue = InputBox(Message, Title, Default)
End Sub This message was edited by hedrijw on 2002-08-30 09:43