Macros - need to add a prompt

J

Jill Powell

How can I have my macro stop and ask for the new data that it needs to insert? I used to be able to do this in Lotus in an amortization spreadsheet that asked for the interest rate and the term of the loan. I want my new macro to stop and prompt for data that is to be inserted in to the cells
 
B

Bob Phillips

Jill,

Look at InputBox in help, this will do what you want.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Jill Powell said:
How can I have my macro stop and ask for the new data that it needs to
Click to expand...
insert? I used to be able to do this in Lotus in an amortization
spreadsheet that asked for the interest rate and the term of the loan. I
want my new macro to stop and prompt for data that is to be inserted in to
the cells
 
Top