JosephFayese
New Member
Hi All,
I need your help regarding using ActiveX Combo box to toggle within sheets in a workbook
This help is urgently needed
This was the code I used before which worked. However, I need it to be able to toggle back and forth and I want the sheet name to reflect
Private Sub ComboBox1_Change()
FollowLink (ComboBox1.ListIndex)
End Sub
Private Sub FollowLink(ByVal intIndex As Integer)
Select Case intIndex
Case 0
Case 1
Application.Goto Worksheets("Sheet1″).Range("A1″)
Case 2
Application.Goto Worksheets("sheet2″).Range("A1″)
The problem I am facing at the moment is that when the switch happens, the name of the combo box doesn't reflect the name of the sheet.
Thanks
I need your help regarding using ActiveX Combo box to toggle within sheets in a workbook
This help is urgently needed
This was the code I used before which worked. However, I need it to be able to toggle back and forth and I want the sheet name to reflect
Private Sub ComboBox1_Change()
FollowLink (ComboBox1.ListIndex)
End Sub
Private Sub FollowLink(ByVal intIndex As Integer)
Select Case intIndex
Case 0
Case 1
Application.Goto Worksheets("Sheet1″).Range("A1″)
Case 2
Application.Goto Worksheets("sheet2″).Range("A1″)
The problem I am facing at the moment is that when the switch happens, the name of the combo box doesn't reflect the name of the sheet.
Thanks