Generate combobox from list but not show the active list sheet

[danny25]

Good afternoon all
I have a workbook with several tabs "FRONT, DATASHEET, NAMES, JOBS, PROCESSES"
everyone works from the "FRONT" tab
I have a button that brings up a user form with a combobox that gets its data from a list on tab "NAMES"
When i press the button the user form appears with the data but it also shows the "NAMES" sheet
i would like it to remain on the "FRONT" sheet whilst i use the userform
I know it has something to do with the Sheets("NAMES"). Activate command but i don't know how to fix it
i have fond this code online
any help would be grateful

Please Login or Register  to view this content.

[sintek]

When i press the button the user form appears with the data but it also shows the "NAMES" sheet

Does the Names tab appear as one of the values in Col C on the NAMES tab

Please Login or Register  to view this content.

[danny25]

Hi Sintek
Thanks
Looks like i really over complicated the formula
Thanks it worked well

[sintek]

Glad to have helped...Tx for rep +