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 "Pour trouver une solution à ses problèmes, il faut s'en donner la peine."

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

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/

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.
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."