CODEWITHSUNDEEP
vbaexcel
benc-m
benc-m

Reputation: 21

Input values into an Input Box that was called by another Macro

I am writing a VBA macro that calls some macros from other Excel workbooks. These Macros are protected and I do not have the ability to see or modify their code. In one of the macros, an InputBox is called.

Is there a way to automatically trigger the OK button so that the InputBox does not load up (or pops up and then closes without prompting the user)? I can live with the default value for the input box to be used (though I'd also like to modify it if possible).

Please let me know if more information is needed - thanks in advance.

Upvotes: 2

Views: 698

Answers (1)

Maciej Los
Maciej Los

Reputation: 8591

Have a look at example:

Sub MyMacro()
   Call MacroInDifferentWorkbook
   'here code to catch InputBox
End Sub

If you're trying to do that in that way, the answer is NO, you can't catch InputBox from MacroInDifferentWorkbook. It was well explained here:

Simulating Multithreading in VBA using Excel
Multithreaded VBA – An Approach To Processing Using VBScript

Upvotes: 1

Related Questions