Select Sheet and then click button

[Diving_Dan]

Hi all,

I am really having one of those days today where the simple things aren't simple.

I have a command button on a worksheet to update various fields. What I want to happen is once I have selected a worksheet from a userform and that sheet has been activated to click the button. I don't want it to happen everytime the sheet is selected so haven't used the worksheet activate function.

This is the code currently. I tried adding cmdUpdateAll_Click and sheets("A Team").cmdUpdateAll_Click to the next line but it doesn't work.

Any help is appreciated as always.

'Manage Team
    If cboTeam.Value = "A" And OptionManageTeam.Value = True Then
    Sheets("A Team").Select
    Unload Me

 

[RayFrye]

If the button is on the Userform, don't unload the form? Have the selection trigger the code to .Select the worksheet.
Your Userform form will still be active
Your code to .Select a worksheet is right on.