Input for Macros

[Sean H]

Hi,

I am trying to write a macro that will be used to update a file. I want to
have some sort of stored input like you can in C++.

something like
input>> "what year is it?"
input>> a

....or however the C code goes (its been a couple years).

Is there any way to do this for an excel macro?

[Leith Ross]

Hello Sean,

You can prompt user input in Excel using the VBA InputBox function. It displays a dialog with the prompt you want to display. The user types in a response and and clicks one of two buttons, OK or Cancel. Entering nothing and clicking OK is the same as clicking Cancel. All responses are string data. If you want more functionality, you can use the InputBox method. See the VBA help files for details on their use.

Sincerely,
Leith Ross