Home

Excel Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-1013482%22%20slang%3D%22en-US%22%3EExcel%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1013482%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20data%20be%20entered%20from%20the%20keyboard%20in%20an%20excel%20macro%20while%20it%20is%20being%20executed%3F%20I%20want%20to%20write%20(record)%20a%20macro%20and%20while%20it%20is%20running%2C%20enter%20the%20location%20for%20saving%20the%20file%20and%20then%20use%20the%20same%20macro%20to%20save%20the%20same%20file%20in%20a%20different%20location%20as%20entered%20from%20the%20keyboard.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1013482%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1013691%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1013691%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F459917%22%20target%3D%22_blank%22%3E%40Bob_9255%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20might%20find%20your%20answer%20here%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Fexcel.application.inputbox%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Fexcel.application.inputbox%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Bob_9255
Occasional Visitor

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.

1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies