Another possibility is to use one form, with a MultiPage control ??
is it possible
Another possibility is to use one form, with a MultiPage control ??
is it possible
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
Thank You.. Here is my sample file for better understanding. You can check when I select optionbutton in Sheet1 then the same optionbutton automatically gets selected in Sheet2. I want both Cmdbutton and Userform perform individually
[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.
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.