Create Combobox to jump from main sheet to other sheets.

[ashen786]

I am working on a project and I am stuck with a problem. I have a combobox set up on the main sheet which takes me to any other sheet on that workbook. If I write a sheets name, say "Megan" it will take me there. The problem I have is that when i type "Megan" it takes me to her sheet when I type "m" The problem with that is if I have another sheet name, say "Mark" it won't take me to that sheet. It is kind of hard to explain so I'll attach the workbook "example sheet". Here is the code:

Please Login or Register  to view this content.

I am also adding another workbook which works the way I want. When i type in the combobox in this workbook, it wont jump to the page until it knows exactly which one I want to jump too.

[HaHoBe]

Hi, ashen786,

you marked your thread Solved - anyhow: to my opinion you should use the ComboBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)-Event instead of the ComboBox1_Change-Event.

Ciao,
Holger

[patel45]

ashen786
I suscribed this thread, please tell me how you solved

[ashen786]

I couldn't get the combobox to work so I used the command button with userform. Two buttons, one "Create Sheet" and the other "Find Sheet" If you would like, I will post the code later today.

[patel45]

Thank, I don't need code