Fill Input Box called by another macro

[MarkElla]

Hi, I have written a macro which calls another macro (called 'Step1'). Unfortunately, 'Step1' is locked by my company so I cannot review or edit it. When 'Step1' is called, it requires a string to be entered into an input box. Is there any way I can send a string from my macro to fill this input box? Thanks

 

[diddi]

hi and welcome to MrExcel
if the inputbox is a userform with a textbox, and you know the name of the textbox then it is possible. if it is indeed an inputbox then that is launched within the locked code and you cannot access it without using sendkeys which is dodgy and unreliable (and may not work anyway if a different subroutine is running)

 

[MarkElla]

Thanks for your reply. When the input box appears, I already have the required data copied to the clipboard. So I can manually use CTRL+V to paste the string then click OK, and the macro 'Step1' continues. But I was hoping to automate the Paste and OK.

 

[diddi]

yeh. i think the problem is going to be that the Step1 macro is running so your macro no longer has control so it cant send anything to automate the process. my thought was to inject the textbox in Step1, but that only works if it is a userform with a textbox as the input. i think you are stuck unfortunately

 

[MarkElla]

ok, thanks. 'Step1' is part of a company-wide spreadsheet, so I won't be able to change it. However, if I can get access to the macro code, does this help me?

 

[diddi]

possibly. can you post the code

 

[MarkElla]

sorry for the delay, as it took a while to get access to the code. The start of 'Step1' is as follows:

Sub Step1()
Project = InputBox("Enter Project", , "123.12345.00000")
If Len(Project) <> 15 Then
MsgBox "Wrong Job Number Format", vbCritical
End
End If
...
...


I would like to send a 15-character string directly to the InputBox.

 

[diddi]

if you cant edit Step1 then because of the way it is set up, you will not be able to do what you wanted.