Hello,

I'm looking for a solution for a data input box. Which will open
automatically on the opening of a worksheet.

When the user inputs data into the text box I want it to populate cell F3 of
the Intro sheet and then go to another macro to open the next data input box.

However, if Cell F3 is already populated I'd like the macro to be bypassed.

Finally, I'd like the information in cell F3 to be used in the next text box.

It would be something like

Data input Box 1

"Hello, what is your first name?"

(user enters first name - say "Dave" - which populates Cell F3)

Data input Box 2

"Thanks Dave (sourced from F3), now what is your surname?"

(user enters surname - say "Smith" which populates cell G3)

etc. etc etc.

The idea is to make a questionnaire more interactive and personal.

Finally, and as an aside, is it possible to make a text box that will only
accept Yes or No answers and populate cells with Yes or No dependent upon the
response?

Thanking you all in anticipation.

Regards,

Tel