Questions

Multiple entry in one cell

+
0 Votes
Locked

Multiple entry in one cell

jaleahmad
I'd like to seek help from anyone to tell me how to insert multiple items (from a listbox) in, say, cell A1. Assume that I have a listbox that contains these items: "One", "Two", "Three",... up until "Ten" (without the quotes). If I click the listbox for the first time and choose "Three" then A1 should contain "Three", if I click the listbox for the 2nd time and choose "Six" then A1 should contain "Three" and "Six", and so on.
+
0 Votes
jaleahmad

Well Peconet,
First of all thank you very much. What that says is on pivot table, and I could not find any related clues/answers to my problem. I need a way to update the content of cell A1 by using a listbox without erasing the old content in A1. Could you help more on this?

+
0 Votes
ozi Eagle

Hi,

You need to do something like this. As I can't remmeber the exact codes etc, I will just outline the process for you.

Create two holding cells, say XX & YY.

Create a macro that

XX = A1(old)
Enter new A1
YY = XX concatenated new A1
A1 = YY

end.

Herb