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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weighted Average Life 1
need a vehicle loan amortization 6
Can some cells remain unprotected in a protected spreadsheet ? 2
Macro within a macro and Macro Prompts 3
loan amortizations worksheets 2
Printing Hidden Cells 8
Excel What is in Excel Macro, Similar to "for" macro in "lotus" ? 1
CUMIPMT 0

Back
Top