Prompt for Data in Excel

[Shaners]

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

 

[Brian from Maui]

Shaners,

Just off the top, you could use "comments" or "data validation". Or you could have instructions on the worksheet itself.

 

[hedrijw]

You could implement a Text Box via VBA, i.e:

Sub Prompter()
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