Nov 16 2019 06:01 PM
Can data be entered from the keyboard in an excel macro while it is being executed? I want to write (record) a macro and while it is running, enter the location for saving the file and then use the same macro to save the same file in a different location as entered from the keyboard.
Nov 17 2019 02:47 AM
You might find your answer here:
https://docs.microsoft.com/en-us/office/vba/api/excel.application.inputbox