Dropdown List Within One Cell

Friends!

Is there any way I could create a dropdown list within one cell (without having to select a range of cells to create a dropdown list)

Now, this particular cell should have the ability to extend if new data is entered into it.

For example, I will enter a name, say, Apple.

The dropdown list should be Apple only.

Now, I will add, say, Orange, Banana, or Kiwi.

If I open the dropdown list it should show all these in it.

Now, again, this should be done within one cell and without having to select a range of cells in order to create this list.

I hope I am explaining thoroughly and I really hope someone could help me out, please.

there is the option to put a comma separated list in the datavalidation setup instead of using a range.

Yes, that one I know but that person doesn't know for whom I am creating this list for.

That person wants to type in the cell instead of going to Data Validation.

We, in our "organization", all use MS Excel 2010. =)

I am willing to take chances with VBA but no helper cells, please.

Hi,
A dropdown list needs a list , this list could be words comma separated in one cell.
like the example below,

validationwithonecell.xlsm

Thank you for your time and reply.

I might be missing something because the file, what it's intended for, does not really serve the purpose.

I mean, it's just a couple of lists that are created through data validation.

Also, when I add anything to the yellow highlighted cell, none of the dropdown lists correspond to it.

The red coloured box does not allow me to add anything to it.

I might have explained myself not precisely.

What I am in need of is whenever I add something to a cell, any cell, the cell should convert itself into a dropdown list. As I proceed to add further names or values into it, the dropdown list should expand and allow further to add more items into it.

I am not looking for any helper cell or any other cell that I might have to fill-in in order for the original cell (dropdown list cell) to correspond or expand.

Please.

But thank you to anyone who has taken the time to reply and help, really.

Enter something in A2.

This is perfect!

But!

We are almost there, though.

How do I delete an item from the list because it doesn't work when I delete something from the list.

Also, just to make things more complicated but really delightful for me, suppose, I would like to create one or more dependent cells corresponding to what you have just created.

Say, Apple is entered into the dropdown list, a message should pop-up and request to enter the Price for it, that price will be entered automatically next to this cell.

Once the price is entered, another message should pop-up and request for Colour.

And so on.

Also, once an item from the original dropdown list is deleted, so too will these dependent cells clear out.

I hope you understand and get the idea.

I really and sincerely hope that it isn't an extra condition to the original query but it's really required and would mean the world to me.

Otherwise, I will close the thread as solved.

But please.

My sincerest apologies.

To be honest, it really just came to my mind that this is also very much required as the original query.

Again, my apologies.

I wrote the code according to your opening post.

Show us some visual examples with before/after in each step in the workbook.

Please see attached.

Example of Prices and Colours are given in Column E, F, and G.

Again, these are just examples and will be deleted and will not be used.

Prices and Colours will be entered as per whatever a user enters.

Also, if a user deletes an item from the original dropdown list, all dependent cells, such as, Prices and Colours, will clear out too.

I hope this helps.

And again, thank you very much for your time and help and please accept my apologies for the mess.

See if this is how you wanted.

Please Login or Register  to view this content.

Yes, a road to perfection.

Here is the thing though, say, I enter Apple, it does ask me all the things that are required, however, whenever I cancel any of the dialogue box, the Apple stays. It should disappear because the process of entering all the details required is not completed and was abandoned midway.

Also, say, Apple's details are correctly entered, and then, I entered Orange and all its related details. If I go back to Apple and select it from the dropdown list, all the dependent cells should release its corresponding details in regard to Apple but it doesn't.

Also, a user shouldn't be able to delete or amend any of the Prices or Colours without having to delete Apple first.

Try the attached.

Yes, again, whenever I select back the Apple from the dropdown list, its related details such as the Price and Colour are not shown, instead it asks me to enter the details of Price and Colour all over again.

Also, when I delete either Apple's Price or Colour, the Apple is not affected, it should be deleted too as it serves no purpose without the Price and/or Colour.

But otherwise the abandoning midway thing is perfect!

This is pure solid perfection, my Sir! :o

I salute you!

Thank you so very much!