pause excel macro for user input

By 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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

2 Ways!

by TobiF In reply to pause excel macro for use ...

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?

Related Discussions

Related Forums