Hi all,
I am hoping that someone will help me put these two things together so
that I can use the combobox / dropdown list not sure which one it
is???
I have tried every thing and people on this forum and others have given
me assistance. BUT! no matter what I do I cannot get this to work.
Please can someone help me!?
Thanks
legepe

See below the values that I have for the combobox / dropdown list
ENE
FEB
MAR
ABR
MAY
JUN
JUL
AGO
SEP
OCT
NOV
DIC

See below the macros that I have to move to each sheet (month)
Sub Macro1()
'
' Macro1 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-ENE").Select
End Sub
Sub Macro2()
'
' Macro2 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-FEB").Select
End Sub
Sub Macro3()
'
' Macro3 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-MAR").Select
End Sub
Sub Macro4()
'
' Macro4 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-ABR").Select
End Sub
Sub Macro5()
'
' Macro5 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-MAY").Select
End Sub
Sub Macro6()
'
' Macro6 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-JUN").Select
End Sub
Sub Macro7()
'
' Macro7 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-JUL").Select
End Sub
Sub Macro8()
'
' Macro8 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-AGO").Select
End Sub
Sub Macro9()
'
' Macro9 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-SEP").Select
End Sub
Sub Macro10()
'
' Macro10 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-OCT").Select
End Sub
Sub Macro11()
'
' Macro11 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-NOV").Select
End Sub
Sub Macro12()
'
' Macro12 Macro
' Macro grabada el 24/07/2006 por Leigh Pender
'

'
Sheets("GAN-DIC").Select
End Sub


--
legepe
------------------------------------------------------------------------
legepe's Profile: http://www.excelforum.com/member.php...o&userid=15485
View this thread: http://www.excelforum.com/showthread...hreadid=564141