Activate workbook of the USERFORM

[cordoda]

Please help me masters,

How do I activate the workbook of the userform?

Scenario:

I'm using multiple workbooks. I still need to activate or select the workbook of my userform for it to work.

If a different workbook is activated and I used/clicked some buttons on my userform, the macros goes on error.

Thank you in advance!

[xlnitwit]

Hi

You should not need to activate a workbook. You should only need to properly qualify objects in the code that isn’t working at the moment.

[cordoda]

Hello,

I just did, it's now working

Here's the code I used,

If ActiveWorkbook.Name <> UserForm4.Caption And UserForm4.Visible = True Then
Application.Workbooks(UserForm4.Caption).Activate

Else

If ActiveWorkbook.Name = UserForm4.Caption Then




**Can you help me how can I use declaration on it?

Thanks

[xlnitwit]

I don't understand, I'm afraid. What declaration? If you properly qualify the objects you refer to in the other code in the form (not what you posted) you should not have to worry about which workbook is active.

[cordoda]

Hello,

can you re-code my code above?

Thanks