Hi geebee-
The most simplistic way is to use an inputbox asking the user to enter data
in it then have the macro write the data to the cell you need it in.

David

"geebee" wrote:

hi,

i have some code.. but i want the user to be able to enter a number in a
spreadsheet that will be used in a later part of the code. the number cannot
be entered before the code. it has to be entered in the middle after a
certain part of the code executes. is there any way to do a pause to allow
the use to enter a number/interact with the spreadsheet and then have the
code resume?

thanks in advance,
geebee