Select more than one option from cell drop down menu so all the items selected show in that one cell.

[lexkhan]

Hi -

Using Excel 2007:
I am trying to set up the file so I can have a drop down using Data Validation menu within a cell and I can select more than one option from that drop down menu so all the items selected show in that one cell.

So for instance in Cell “A” line 2, from the drop down I want to be able to select Option 1: “Test 1"
Option 2: "Test 2"
and have it all show in one cell.

Please help!

Thanks,
lex

 

[Smitty]

You can use a List Box.

HTH,

 

[lexkhan]

You can use a List Box.

HTH,

I want to select multiple selections in one cell and I believe there is a need of VB Code. Can you help me with that or point me to the right direction?

Thanks for your earlier response.