Drop down boxes and forms

[CloudenL]

If im using Data Validation List for drop down with 3 choices. Is there a way to make a choice and have a form pop up with additional choices, that have checkboxes or optionbuttons, and once those options are chosen, have them show up on a specific worksheet?

Am i making sense? I know what i'd like to do, just not sure if it can be done.

[Bob Phillips]

It can be done, and I have an old technique with old-style dialogs. Post some data, a workbook, and lets see what we can work with.

[CloudenL]

Thank You. Let me know if this workbook is okay. just basic, but it shows what i am trying to accomplish i think. Hard to put what is in my head to paper some days. And i'm still trying to learn VB. :)

[CloudenL]

:help Still looking for any advice on this. Does anyone have any thoughts on how i might best accomplish what im trying to do.

I want a drop down with choices. Once u pick a choice i want another box to pop up that offers products within the choice group. I want those choices to have check boxes and once a box is checked, i want that product to show up on another spreadsheet.

If i need to repost another spreadsheet with more detail, please let me know.