Hypelinked Combo Box in Excel
Closed
earthworm
Posts
11
Registration date
Saturday 4 April 2009
Status
Member
Last seen
31 December 2009
-
17 May 2009 à 03:42
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 - 22 May 2009 à 16:59
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 - 22 May 2009 à 16:59
Related:
- Hypelinked Combo Box in Excel
- Excel mod apk for pc - Download - Spreadsheets
- Arrow keys not working in excel - Guide
- Setting up a box account - Guide
- How to change date format in excel - Guide
- Media box apk - Download - Video recording and streaming
4 responses
earthworm
Posts
11
Registration date
Saturday 4 April 2009
Status
Member
Last seen
31 December 2009
1
17 May 2009 à 11:37
17 May 2009 à 11:37
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
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
7181
Registration date
Saturday 7 April 2007
Status
Moderator
Last seen
14 February 2026
491
22 May 2009 à 16:59
22 May 2009 à 16:59
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.
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
7181
Registration date
Saturday 7 April 2007
Status
Moderator
Last seen
14 February 2026
491
17 May 2009 à 10:55
17 May 2009 à 10:55
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
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 4 April 2009
Status
Member
Last seen
31 December 2009
1
17 May 2009 à 11:51
17 May 2009 à 11:51
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/
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/