Hypelinked Combo Box in ExcelClosed

Question

My Query is 

I Have made a Combo Box in Excel Sheet 1 in that Combo Box i have 2 sheets


Sheet 1 and Sheet 2 . 

Now i want to Hyperlink / vba code , so that when i click on sheet 2 in combo box it jumps to sheet 2 . 

Prompt help will be appreciated . 

Same Sheet : 	http://rapidshare.de/files/47192773/1.xls.html

Please make the changed in the above sheet and share

aquarelle · Answer

Hi,

First, you have to create a macro and after, you have to associate the macro to your combo box by clicking right on the combo, choose "assign a macro", select the macro you want and click on "OK".
Example with your file : http://www.cijoint.fr/cjlink.php?file=cj200905/cijJwWmCTo.xls

Best regards

earthworm · Answer

ok i made a macro , 

but it shows me only sheet 2 if i make it work 

when i click sheet 3 , it shows the same sheet 2 instead of sheet 3 

please advice.

Here is the code 

Sub Macro2()
'
' Macro2 Macro
'
' Keyboard Shortcut: Ctrl+Shift+V
'
    Range("A2").Select
    Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End Sub

earthworm · Answer

Please upload the sample here . 

I tried your tip , when i click sheet 1 , it shows last function of macro which is Sheet 2 which is when i click sheet 2 when macro is recording . 

its not showing two different functions in combobox  :(

please upload my excel with combobox working here

http://rapidshare.de/

aquarelle · Answer

Hi,
Sorry to have not replied earlier but I tried to find something to use hyperlinks with a macro but nothing worked.
But If you want, I could propose you another method to select the different sheets.

Hypelinked Combo Box in Excel

4 responses

Similar discussions

Subscribe To Our Newsletter!