Userform copy textbox value to different range depending on Combobox selction

[icsiszer]

Hello to all!

This is my first post here and I'd just started learning VBA.

I'm working on a project that in one point it needs a userform with the following function:
I will have a combobox with 3-4 values, and textboxes for each month (so 12 textboxes).

What I need now is that the values from the month to be added in different ranges depending on the selection from the combobox.

I hope somebody will help me out.

Thank you a lot!

 

[Johnny C]

You get the selection form the Combobox using

variablename = userform.comboboxname.VALUE

and using either IF statements or a SELECT CASE statement, set the textboxes

IF variablename = "X" Then userform.textname.VALUE = "Value 1"

or...

SELECT CASE variablename
   CASE "X"
     userform.textname.VALUE = "Value 1"
   CASE "Y"
      userform.textname.VALUE = "Value 2"
   CASE ELSE
       userform.textname.VALUE = "Value 3"
End Select

 

[icsiszer]

Thanks a lot,

I will give it a try to se what can I get out of this.