Prompt for user information at startup

[Russ3Z]

I wish to prompt the user to enter various name and company
information when they first run a certain spreadsheet. The
information is then taken and entered on a sheet in the appropriate
areas automatically, serving as a future template.

So, a series of Prompt "Input Company name:" var A statements, for
example.

The question then is, is there a good way to encode this to run only
the first time the spreadsheet is run, or is it simply a case of
having to have the code on the Workbook's code page and have it check
to see if the information is already there, each time it opens?

Your help is most appreciated.
Russ

 

[Guest]

You could have the first input box ask for a User ID or some short answer
that is stored with the other data. The macro could then search the related
column and, if found, skip the other questions.

 

[Guest]

The macro could check to see if the Company Name cell is empty and proceed
accordingly.

 

[Russ3Z]

Ok, thats basically what I had in mind. Thanks for the input guys.

Russ