| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macros
How can I write a macro that needs to wait for a user to input information
and then continue to finish the macro action |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macros
Just ask for it:
Sub FillMeIn() x = Application.InputBox(Prompt:="give me some data", Type:=2) End Sub -- Gary''s Student - gsnu200840 "Frank" wrote: How can I write a macro that needs to wait for a user to input information and then continue to finish the macro action |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros: can you copy macros from one doc to another? | Excel Discussion (Misc queries) | |||
| Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
| Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
| Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
| Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Linear Mode
