VBA code to enter data in a userform created by another macro

[Phil_T123]

Hi,

So, the problem I'm having is that some code I am writing calls another macro. This second macro has a userform with fields that must be completed before it will continue.

Is there any way I can have code in the first macro that will enter data into the userform from the second?

The main problem here is that I don't have access to the code in the second macro. As far as I understand, this means:

(1) I can't bypass the form and pass the variables directly to the second macro's code as I can't edit the second macro.
(2) I can't call an event when the userform activates as that code would need to be in the second macro and I can only edit the first, which pauses once the second macro is called.
(3) I can't use an application event as there isn't one that covers a userform popping up.


Any ideas?

Thanks in advance!


Phil.

 

[Norie]

Phil

Do you have any access to the userform or it's code?

 

[Phil_T123]

Hi Norie,

No access If I did then I'd bypass the userform altogether.

 

[Phil_T123]

I can call the macro and then enter the data manually, but the project is password locked.

 

[Norie]

Phil

I was going to suggest you could try accessing the form via the UserForms collection but if the project is password protected I'm pretty sure that's not going to be possible.

The only other way I can think of would be to use the Windows API and treat the form as a 3rd party application.

 

[Phil_T123]

Hi Norrie,

That isn't something I had considered, so I will look into this and have a play around, when I get a chance.


Thanks for your help!

Phil.