macro 'message box' versus 'data form'?

[beelzebubble]

Hi,

I've got an existing macro that performans a number of calculations. At a certain point within the macro, I would like to prompt the user of the macro to enter some numerical information to be inputted into a column of a specified worksheet. Once the data are inputted, the macro would continue executing calculations.

I thought of including a Message Box within the routine which would prompt the user to enter the necessary data, but the problem is that once the Message Box appears, the user must 'click' okay to be able to get to the Worksheet, which basically terminates the macro. Is it possible to create a message box that allows the user to add data to the worksheet and then click something like 'continue'?

Perhaps a Data Form would be more useful in this case, but it would be tricky, as the 'variable names' for which data will be needed to be entered will change from project to project (but will all be in Column A of a specified worksheet).

Any ideas or tips are much appreciated.

 

[njimack]

Rather than a Message Box, sounds like you need an Input Box