Userform - Combobox Cell selection Name Range

Good day everyone,
I am looking for help doing the following:

I have 3 name range in a control sheet ("Control")

Namerange Cat1, Cat2, Cat3. All of the name range are different. I am trying to cut down on my Userform that have each a userform with combobox selection.

Frmcat1, frmcat2 frmcat3.

I need to simplify my life. I need that if the user selects anything between F5:F20 to generate the userform and select range Cat1. If the user Select G5:G20 then to generate Cat2 and so on...

So on userform Initialize look if the user is in Column F, is yes then Cat1. If user in Col. G then Cat2 and final if user is in Col H to have Cat3 generate in the combobox.

How would I go and do this?

Genious...just had to change the Private Sub UserForm_Initialize()

My god work way much better then having 10 million userform lol and I don't really like to use multi-pages therefore this way is perfect.

Thank you so much Norie



Excel Noub

To Private Sub UserForm_Initialize()

Your code was missing the "Sub"