Create a Dynamic User Form

Hi,
I needed some help in creating a dynamic user form. What I need to do is create a user form, which will have a certain number of values, based on some criteria. Example - Red, Blue, Green, Yellow for 1 criteria and Orange, Pink, Purple, White, Mauve for another criteria (These ranges of values can be present in another sheet in different colunmns). Next to these values should be check boxes where the user can select a subset of these values. After which I will be using the user selected values for some other calculations.

Another approach could be select every value that I need in one box and click a button, which moves the value from one box to another box, and I use the values selected (that is, present in the 2nd box) for my calculations.

Please let me know how to do this! And thanks for all the help!

Make a dropdown that contains the values that you want to pass. If you are using Textboxes, name the textbox and then attach whatever values you want the user to be able to choose from. In VBA it will look like this:

With TextBox1
.AddItem "Whatever you want to add"
.AddItem "And whatever you want to add here"
End With

With TextBox2
.AddItem "option for this dropdown"
.AddItem "2nd option etc...."
End With

Then create another textbox and name it something, say "Input" and write the code like this:

Input = Me.TextBox1.Value & " " & Me.TextBox2.Value

Hope this helped.

Nate