Menu Bar

[asad.ermo]

Dear All ,

I need to create a combo box populated with list of sheets names in the workbook.

Regards

[Olly]

Try:

Please Login or Register  to view this content.

[asad.ermo]

Thanks for your help but code you have provided not worked

[Olly]

Yes, it does. Show me how you're trying to use it.

[asad.ermo]

I have run code by paste into VBA Module and when run it nothing happened and no error message

[Olly]

You didn't specify where your combobox is, so I gave you a function which populates a specified combobox. You have to call that function as part of your existing code, and specify the combobox object you are referring to.

For example - if your combobox is on Sheet1, and is called ComboBox1, then you could use:

Please Login or Register  to view this content.

[asad.ermo]

i want to create a combo box like this so that when i click menu then it goes to menu worksheet a snapshot is attached

The combo box i have created is on sheet 1


Regards

[Olly]

It's hard to tell, from an image (much better to attach an actual workbook), but I suspect you've inserted a Form Control Combobox. You'd be better using an ActiveX ComboBox, if you intend manipulating it with VBA.

[asad.ermo]

Thanks for your help

I have attached a screenshot of actual workbook

kind Regards

[Olly]

Yes, as I guessed, you've inserted a Form Control Combobox.

On the Developer tab, click the Insert dropdown, and you'll see two sets of controls - Form Controls and ActiveX controls. Because you want to control the ComboBox behaviour with VBA, it's better for you to use the ActiveX control.

[nigelog]

Attached file will automatically list all worksheets in workbook in a userform. Double Click will take to selected worksheet. Visible from any worksheet makes for easy navigation

[Olly]

@nigelog That's not what OP asked for, though...

[xlnitwit]

Yes, as I guessed, you've inserted a Form Control Combobox.

That picture shows an ActiveX combobox.

[nigelog]

I guess not but someone might find it useful in a multisheet workbook

[Olly]

That picture shows an ActiveX combobox.

You're absolutely right - my error!

In which case, the code I posted in #2 and #6 should work just fine:

Please Login or Register  to view this content.

To activate the selected worksheet, something like this in the worksheet module:

Please Login or Register  to view this content.

See attached workbook for worked example.