| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I insert a prompt into an Excel macro?
I want to use goal seek in a macro. At the point in goal seek that the user
is promted for a value to acquire, I want to stop the macro automatically to enter the value and then allow the macro to proceed after the value is entered. Is the possible in Excel? |
|
#2
|
|||
|
|||
|
Look at InputBox() in VBA help
"TangoHammer" wrote: I want to use goal seek in a macro. At the point in goal seek that the user is promted for a value to acquire, I want to stop the macro automatically to enter the value and then allow the macro to proceed after the value is entered. Is the possible in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
| Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions | |||
| How do I insert the date using a macro | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| Save prompt for Excel 2003 | Setting up and Configuration of Excel | |||
Linear Mode
