adil mehboob
08-08-2014, 10:06 PM
In Excel 2010:
I have a main sheet i.e (Sheet1) --Usually default sheet in Excel.
I want to add a combo box in this Sheet1.
I have four other sheets too in same workbook that is opened i.e. (Sheet2,Sheet3,Sheet4,Sheet5,)
Now i want to add only Sheet2 name and Sheet4 name in that combo box.
After that when i click on Sheet2, it should open Sheet2 and Sheet3.
Similarly, When i click on sheet4, it should open Sheet4 and Sheet5.
is there any VBA code for this ?? Please help me in this regard..
I have a main sheet i.e (Sheet1) --Usually default sheet in Excel.
I want to add a combo box in this Sheet1.
I have four other sheets too in same workbook that is opened i.e. (Sheet2,Sheet3,Sheet4,Sheet5,)
Now i want to add only Sheet2 name and Sheet4 name in that combo box.
After that when i click on Sheet2, it should open Sheet2 and Sheet3.
Similarly, When i click on sheet4, it should open Sheet4 and Sheet5.
is there any VBA code for this ?? Please help me in this regard..