VBA to automate text input into input box

[energywatch]

I am in need of VBA code so that I can fill out an input form generated by someone elses macro input box. (I am the user, not the one developing the input box).

I am working to streamline a whole cluster of macros and this input box is currently my bottleneck. When the input box pops up, instead of me manually typing, I want to autofill the space with "104" and then click 'ok' uisng VBA.

I can not modify the actual VBA that created the input box (ie make 104 the default) because other users need the box to be blank.

I have searched for this function many places and sofar only find out how a developer would change the original vba code, not how a user can interact with an input box by using vba.

Thank you in advance,
Janette

 

[Gary McMaster]

Maybe you could make your VBA code identify the user and set an input box default if you are the user and leave it alone for everyone else?

Gary

If Application.UserName = "Janette" Then
    'Make input box default to 104
Else
    'Leave input box alone
End If

 

[energywatch]

Hi Gary,

I am not allowed to modify the original VBA code, it is protected. I, as the user, interact with these macros as a user, not a developer. I therefore can not change any of the original VBA code that causes the input box to appear. I need an independent macro that references the input box when it appears, fills it in and clicks ok. I can not change the behavior of the input box directly. If I could, your idea would be a good one.

 

[Gary McMaster]

There are programs available that will click OK, or whatever, for you (see link below) but I'm not aware of any programs that will also complete an input box before doing so.

Download PTFB (Push the Freakin' Button) - MajorGeeks

Gary