UserForm with ComboBox? is it possible?

[novak100]

Hello everyone.
What I've got is an UserForm with an InputBox. Whatever user gonna type there - it will be used as a name for new worksheet.
It's fine and it is working. But what I would like to do is to add a ComboBox with selection of 3 words (for example: car, truck, bike). I need that in my future code where I will be looking for a worksheet based on its name, so those 3 words from combobox would be kind of a tags for each worksheets. For example:

Please Login or Register  to view this content.

So in that case it wouldn't matter what name the user would give to the new worksheet, cos he will have to chose a type from ComboBox.
So the final name would something like that:
strName = InputBox + ComboBox
ActiveSheet.Name = strName
Bellow is a working code for a user form without a comboBox.

Please Login or Register  to view this content.

[MaczaQ]

try this (when you add combobox on your form)

Please Login or Register  to view this content.

[novak100]

Thanks for that.
Using Your ideas i was able to solve my problem.
I decide to share my solution here in case someone in future will be looking for informations how to get data from combobox.
This is my piece of code:

I got a macro which loads data from selected files and at the end of that macro im calling for my userform called"SheetNewName" :

Please Login or Register  to view this content.

In my userForm I've got a comboBox called combo and confirmation button called "CommandButton1".
This is the piece of code behind the button:

Please Login or Register  to view this content.

As you can see UserForm will hide itself and run another macro called "GetSheetName".
This is code:

Please Login or Register  to view this content.

It will activate "sheet3" (whole uploaded data will go here), rename it to whatever is in "FullName" and create new worksheet called "sheet3" for future data uploads.