combo box help

[Acehole]

hello all,
i have a combo box that i select a number from 1 to 10.
this number is then linked to cell d9.
what i need is when the number is selected, lets say 4. excel looks at d9 and associates another action with that number value.
so d9 says number 4 this then opens up another sheet on excel(say sheet 4), when number 2 is entered it selects another worksheet (sheet 2). etc etc. this is where i will put other information, how do i make it make that link for me.

thanks

 

[Andrew Poulsom]

Where is your ComboBox and where is it from - Control Toolbox or Forms Toolbar? A solution will require VBA code. Is that OK?

 

[Acehole]

hello, andrew good of you to reply, thanks.
apologies for the scant information still very much a novice.

the box is via insert-active x control.
it is on sheet 1 the numbers are selected via a range called numbers on sheet 2. apologies if this doesnt clarify what you needed to know to enable you to help me.

 

[SteveO59L]

Something along the lines of

Private Sub ComboBox1_Change()
Sheets("sheet" & ComboBox1).Activate
End Sub

 

[Acehole]

thanks for the reply,
however i am a real dummy at this where would i have to put the code for any of it to work.

 

[SteveO59L]

Enter design mode. Select your combo box, right-click and you should get a dialogue. About halfway down you should see a " View Code" option

 

[Acehole]

thanks
I did that and entered the code but got subscript out of range?
I guess it is waiting for information to be added or the correct information.

 

[SteveO59L]

Send me a p.m with your e-mail and I'll send you a working sample

 

[Acehole]

pm hopefully sent.
again ta for the help

 

[SteveO59L]

incoming