OK Msgbox

Hello Gurus,

I am in need of the code to be able to do the following.

I am running a macro that copies a picture > opens another excel spread sheet > and pastes it to a user specified range. All works well as is.

Problem:

I cannot change the worksheet before specifying the range.

Is it possible to pause the macro using a msgbox "Select worksheet" > user select the worksheet > and hit "OK" button to resume? I would think I could place the code just before the set Rng command.

Please Login or Register  to view this content.

If so, please help, I am beyond my understanding of VBA.

TIA,
Tim

The inputbox method you give allows you to change the worksheet by clicking on the tabs at the bottom. However, the Rng.select method won't work unless the parent sheet is active. So you would need:

Please Login or Register  to view this content.

Why not use the same method you used to select the range?

Please Login or Register  to view this content.

Thanks Yudlugar!

Works Perfectly.

Tim

thanks for looking into this Solus and John.

I used Yudlugar's suggestion and it works great without a message box.

Thanks for helping!