How do you write a macro that adds ALL worksheets in a combobox?

[kjy1989]

Hi All,

I have a combobox in a userform, when I load the userform I want the combobox to show ALL the sheets in the workbook. something like:

Please Login or Register  to view this content.

Then after that, all the sheets will be in combobox_allsheet

how do i do this?

[HaHoBe]

Hi, kjy1989,

maybe like this:

Please Login or Register  to view this content.

I would recommend to use another name for your variable as Worksheet is a VBA keyword.

Ciao,
Holger

[kjy1989]

Hi, kjy1989,

maybe like this:

Please Login or Register  to view this content.

I would recommend to use another name for your variable as Worksheet is a VBA keyword.

Ciao,
Holger

Thanks Holger,

I'm new with dealing with Worksheets so even the simplest commands im having trouble with.

I have another question though

How do you add a new worksheet that will be named after a value in the textbox.

something like:

Please Login or Register  to view this content.

[kjy1989]

Hi, kjy1989,

maybe like this:

Please Login or Register  to view this content.

I would recommend to use another name for your variable as Worksheet is a VBA keyword.

Ciao,
Holger

Thanks Holger,

I'm new with dealing with Worksheets so even the simplest commands im having trouble with.

I have another question though

How do you add a new worksheet that will be named after a value in the textbox.

something like:

Please Login or Register  to view this content.

how do i do that?



*Edit: Sorry double post

[HaHoBe]

Hi, kjy1989,

a different question but I would check the contents of the textbox to be longer than zero (as well as not being longer than 31 and holding no special characters and name not being present in workbook) and use something like

Please Login or Register  to view this content.

Ciao,
Holger

[kjy1989]

Hi HaHoBe

I apologize if it's in the forum rules that one thread would require one question (I read the rules i guess i missed/forgotten that one)
Thanks the code works. The reason why I posted another question in this thread rather than starting a new one is that my question was so simple and stupid(?) that I wouldnt want to flood the threads with very simple questions. If that is the correct way then so be it.

And yes i do a google search before i ask these questions in case you might say that i should do a search on simple commands before i post something here.

Anyway, apologies and if that's the proper way of posting then i'll just start a new thread for every questions. Again, thanks Hahobe!