Questions

pause excel macro for user input

+
0 Votes
Locked

pause excel macro for user input

pctrain
Hi all. I have written an excel macro that filters data from a Date column and from a time column. I need to pause the macro so that the user can type in the date in the first filter and then again so the user can type in the start time and end time. How do I insert a "User Prompt" command in a macro? Thanks, Sharon
  • +
    0 Votes
    TobiF

    To answer your question: Look for the command inputbox.

    But, maybe it's easier for you and for the user if you add a couple of parameter fields on the top of the sheet, where the user can enter the filter data before invoking the macro?

  • +
    0 Votes
    TobiF

    To answer your question: Look for the command inputbox.

    But, maybe it's easier for you and for the user if you add a couple of parameter fields on the top of the sheet, where the user can enter the filter data before invoking the macro?