Hypelinked Combo Box in Excel

Closed
earthworm Posts 11 Registration date Saturday April 4, 2009 Status Member Last seen December 31, 2009 - May 17, 2009 at 03:42 AM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - May 22, 2009 at 04:59 PM
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
Related:

4 responses

earthworm Posts 11 Registration date Saturday April 4, 2009 Status Member Last seen December 31, 2009 1
May 17, 2009 at 11:37 AM
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
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 491
May 22, 2009 at 04:59 PM
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.
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 491
May 17, 2009 at 10:55 AM
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 Posts 11 Registration date Saturday April 4, 2009 Status Member Last seen December 31, 2009 1
May 17, 2009 at 11:51 AM
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/