Hypelinked Combo Box in Excel [Closed]

Report
Posts
11
Registration date
Saturday April 4, 2009
Status
Member
Last seen
December 31, 2009
-
Posts
7083
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 25, 2020
-
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

4 replies

Posts
11
Registration date
Saturday April 4, 2009
Status
Member
Last seen
December 31, 2009
1
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
7083
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 25, 2020
475
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.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
7083
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 25, 2020
475
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
Posts
11
Registration date
Saturday April 4, 2009
Status
Member
Last seen
December 31, 2009
1
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/

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!