Pause Macro

[skygirl65]

I have a simple macro in excel that I would like to change the date in the header before moving on... how do I tell the macro to pause and wait for me to type in the Month?

 

[SkipVought]

Hi,

You can dan input prompt using the InputBox Function.

Skip,
[sub]
[red]Be Advised![/red] The Vinyards of Texas have produced a wine with diuretic dimishment...
Pinot More![/sub]

 

[AnotherHiggins]

In the future, please post macro questions in the VBA forum (forum707 - VBA Visual Basic for Applications (Microsoft) Forum).

You can interupt a macro by pressing [Escb], but why not have the macro prompt you for the month?

...
MyDate = inputbox "Please enter the Date you would like to appear in the header"
...

You could get fancier and change how it appears vs. how you enter it. But if you need further help, please start a new thread in forum707.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[AnotherHiggins]

That was supposed to be [Esc], not [Escb].

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[xlbo]

Alternatively, if you simply want to enter the data into a cell, you can use

.....code runs

stop

.....code restarts

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question