Create dropdowns in forms

**kryt0n** · 06-15-2010, 07:52 AM

Fairly new to VB and have an issue desperately needing help with.

So, I have a number of columns which need to be populated.

A......B.....C.....D.....E

For this, instead of havinig a drop down menu selection for each I would like a form containing the drop downs.

When you have selected a line of drop downs there is a button which allows you to view the selection in a pane. Also an option to increse the number selected.

Finally an option which 'Adds' the selected lines into the worksheet. See attached diagram for a better explaination

NB - I understand and do have a separate worksheet containing the data needed in the drop down menus. (it is text, not numbers, numbers were easier to give as an example)

**kryt0n** · 06-15-2010, 08:35 AM

It's an excel-VB question. I just attatched a .doc because I used a diagram to explain my situation.

**kryt0n** · 06-15-2010, 09:44 AM

Really really need some advice with this guys! is there anyone to talk me through it?

**royUK** · 06-15-2010, 01:19 PM

If you want help with Word,add a Word Document. It makes sense to add an Excel workbook for help with Excel

I think you want a userform but I haven't a clue what you need to do

**kryt0n** · 06-16-2010, 04:11 AM

Again, only reason I added a .doc was because I have used a diagram which is easier to explain my situation.

Anywho, here is a .xls as well so you can see my situation.

Please, any advice would be great. I really don't know where to start other than I have a separate worksheet with the items I want in the drop down lists and I have already created the form as it looks on the attached.