Posts by DaljeetS

  • How to use an Userform [VBA] multiple times in excel sheet

    Roy, hope you would have clicked both "SELECT" button in "Sheet1" & "Sheet2"

    I want to use the same "Userform9" for both CommanButton's "SELECT" in each sheet

    Suppose, If I click on "Select" Button at "Sheet1" then Userform9 will open. I can select any Option/Radio Button in Userform9 and save/close it.

    The issue is when I click on "Select" Button at "Sheet2" then Userform9 opens, but the same Option/Radio Button selected by default that I had selected in "Sheet1".


    If I select other Option/Radio Button at "Sheet2" in Userform9 and save/close it, then the same thing happens with "Sheet1" Userform.

    In "Sheet1" Option/Radio Button selected by default that I have selected in "Sheet2".


    I know I can make replica of Userform with different name which will work perfectly. But, I have several sheets in my original Workbook.

    This is just a sample to understand my issue.

    I want know with the same Userform , How can I perform them individually. I mean If I do some change in "Sheet1" Userform that should not reflect or select any Option/Radio Button in "Sheet2" Userform. Both should perform separately.


    Hope you have solution for me :)

  • How to use an Userform [VBA] multiple times in excel sheet

    [xpost][/xpost]

    mrexcel.com/board/threads/how-…s-in-excel-sheet.1172378/

    I am using Userform1 multiple times in different Excel worksheets. But, If I select Checkbox in the first Userform then another Userforms checkbox automatically selected. How can I separate them?

    I'm a beginner in coding so do not have much idea how can I segregate them to perform individually.

    Code
    Private Sub CommandButton7_Click()
UserForm1.Show
End Sub

Private Sub CommandButton8_Click()
UserForm1.Show
End Sub

    [Blocked Image: https://i.stack.imgur.com/3uquF.png]

  • VBA CODE to copy dropdown list selection

    I have 2 Dropdown List with the same options (Included and Excluded) in different sheets. If I select " Included" in one dropdown list, it should also select "Included" on another dropdown list and vice versa. I am new in coding please help me out to crack this.