Macros - need to add a prompt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top