Software

Ask something
Question Locked

pause excel macro for user input

0 helpful
2 replies

by pctrain

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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

2 replies

by 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?

This discussion is closed to new replies.