Hello There,
I have a UserForm with the following objects:
1. CheckBox
2. ComboBox
In worksheet 'One', there is a button 'Menu'. On click, it takes to the Userform.
The required functionality is as follows in the Userform:
1. On worksheet 'One', columns A to D are shown and hidden. This is based on the checkbox (CheckBoxShowColumns). In the Userform, when the User checks the Checkbox , and clicks OK (Button), then it should show columns A to D. When it is Unchecked, then it should unhide the columns A to D
2. In the ComboBox, it should populate the names of the Worksheet in the current workbook. The User selects a value from the combobox and when he click OK (Button) then it should navigate to the worksheet that is selected in the combobox.
I tried to do this in VBA, but it doesn't work properly.
Please find attached the workbook for your reference. Looking forward for your help and advise.
Regards
Don
I have a UserForm with the following objects:
1. CheckBox
2. ComboBox
In worksheet 'One', there is a button 'Menu'. On click, it takes to the Userform.
The required functionality is as follows in the Userform:
1. On worksheet 'One', columns A to D are shown and hidden. This is based on the checkbox (CheckBoxShowColumns). In the Userform, when the User checks the Checkbox , and clicks OK (Button), then it should show columns A to D. When it is Unchecked, then it should unhide the columns A to D
2. In the ComboBox, it should populate the names of the Worksheet in the current workbook. The User selects a value from the combobox and when he click OK (Button) then it should navigate to the worksheet that is selected in the combobox.
I tried to do this in VBA, but it doesn't work properly.
Please find attached the workbook for your reference. Looking forward for your help and advise.
Regards
Don