Automatically Run a Command when a UserForm is Activated

[Denny57]

I have a Module which calls information via a command button in a User Form from other worksheets and which I need to use a number of times whilst the User Form is open. I would like the module to automatically run when the User Form is activated

Is this possible? If so I assume I would probably be wrong in expecting that the instruction would be included as below as it seems that my logic is different to that of VBA syntax .

Private Sub UserForm_Initialize()
CommandName (e.g. cmdCallData)
End Sub

Many thanks

 

[Trebor76]

Hi Denny57,

Try this:

Call cmdCallData_Click

Regards,

Robert

 

[Denny57]

Thank you I almost had this, I omitted _Click which to my mind would require an action