Pause

[WoodyHays]

I need to pause a macro to allow a user to make selections from two drop down boxes, data validation, then resume the macro.

I have tried InputBox () and using a time function to wait for 10 seconds, but neither worked properly in that the user couln't make the data selections.

Is there another way to accomplish this?

Thanks,
Woody Hays

[Ivan F Moala]

On 2002-05-20 07:09, WoodyHays wrote:
I need to pause a macro to allow a user to make selections from two drop down boxes, data validation, then resume the macro.

I have tried InputBox () and using a time function to wait for 10 seconds, but neither worked properly in that the user couln't make the data selections.

Is there another way to accomplish this?

Thanks,
Woody Hays

If you use Excel2000 then the only way to
accomplish this is via a Userform with it's
ShowModal property set to False.
This will allow you to edit the sheet.

You will have to prgm around the issues of
deciding when to continue with your code.
But that can be accomplished vai cmdbutton
to continue with your routin.
You may also consider Locking the ranges that can be selected.

HTH

[WoodyHays]

Thanks Ivan,

I think I will take the easy way out on this one and brak the routine into 2 parts and have the users click twice with a selection in between. Not very elegant though is it?

Woody Hays

[Ivan F Moala]

On 2002-05-20 07:57, WoodyHays wrote:
Thanks Ivan,

I think I will take the easy way out on this one and brak the routine into 2 parts and have the users click twice with a selection in between. Not very elegant though is it?

Woody Hays

Well if your confident your users will not
mess it up then go with it.
If you see any possibilty that it could ?!
Then repost on how to do it.....
Someone is bound to help you out.