allow user to change the insertion point

[stuck]

I'd like to start a macro asking the user to put the cursor where they want to insert a table and then have the code wait while they do that, i.e only proceed after the user has clicked something to confirm it is OK to carry on, can that be done?

Ken

[HansV]

You cannot do that in a macro itself, you need a userform.

1) Use a macro to open a userform whose ShowModal property has been set to False.
2) The userform should contain a label with instructions for the user to place the insertion point, and a command button whose On Click event procedure executes the rest of the code (or calls a second macro that performs the required steps)

[stuck]

Ah, OK, I see now.

Ta!

Ken