Ask for date

[Carole O]

I receive a file (bi-weekly) which is then sorted by Macro into various
worksheets and sent to Departments for their research and response. How
could I get a message to appear which would ask me for the date the
worksheets will be sent to the departments and populate it into the database
during the sort process?

TIA
Carole O

 

[CLR]

Assuming that you would like this to be done as part of the process run by
your "sorting" macro........that macro itself would have to be modified.
Whoever wrote the original macro should be able to incorporate this new
function.

Vaya con Dios,
Chuck, CABGx3

 

[Carole O]

I recorded the 'sorting' macro. I know there is a way to do this, I just
either have forgotten or don't know how. After the macro is started, it
should pop up a question "What is the send date?" and give the person running
the macro an opportunity to respond. The macro will then write that date to
the 'send date' column in all the sorted files.

Hope this clarifies what I am looking for.

Carole O

 

[Fred Smith]

You want InputBox, as in:

SendDate = InputBox("What is the send date?, , <default if wanted>)