Getting Excel to perform

[jimmyquinn]

I am compyling a database of names and surnames and additional fields.

When I open the spreadsheet I want excel to ask me Questions and me type in the answers so these will then be stored on the spreadsheet, Just really a quick question to ask whether or not this is possible and if possible how exactly it can be done,

All the best

Jimmy

[Bryan Hessey]

I am compyling a database of names and surnames and additional fields.

When I open the spreadsheet I want excel to ask me Questions and me type in the answers so these will then be stored on the spreadsheet, Just really a quick question to ask whether or not this is possible and if possible how exactly it can be done,

All the best

Jimmy

Hi,
You will need some VBA code which triggers a WorkBook or WorkSheet _Open Event.

Then you can use the 'Msgbox' with it's various forms to ask/receive your question and answer.

The thread http://www.excelforum.com/showthread.php?t=584092 has many useful links to VBA 'how to' including the VBA for Beginners section.

hth
---

[sweep]

Hi,

It can be done. Put the code you're going to use in the

Please Login or Register  to view this content.

module of the workbook.

You can use

Please Login or Register  to view this content.

to ask the questions, and

Please Login or Register  to view this content.

to enter them into your spreadsheet.