Holding an Excel macro until a Word selection has been made

[GOGGS75]

Hi,

I have been trying various techniques without success and was hoping someone could help with a basic step when working with more than one application.

I am trying to set up a macro that starts from Excel, then allows a selection from a Word Document and continues in Excel once the selection has been made.

The problem is how to pause the Excel macro until a selection has been made in Word ?

I have been looking for some Do Loop command without success ?

I have managed to pause the Excel macro by using a Msgbox command immediately after Word is displayed but am looking for something better.

Thanks for any help.

Goggs75