close

I would like to use data validation to populate entries into a cell, however,
I 'd like to be able to enter multiple entries from the list into one cell.
Is this possible?
--
Marie

You can do this with programming. There's a sample file he

www.contextures.com/excelfiles.html

Under Data Validation, look for 'Select Multiple Items from Dropdown List'MarieB wrote:
gt; I would like to use data validation to populate entries into a cell, however,
gt; I 'd like to be able to enter multiple entries from the list into one cell.
gt; Is this possible?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlHi Debra
The sample file this points to seems to answer a different question, I
cannot find how this allows the input of multiple 'answers' into one cell.

Saying that, I loved what this sample file does also!
--
Mariequot;Debra Dalgleishquot; wrote:

gt; You can do this with programming. There's a sample file he
gt;
gt; www.contextures.com/excelfiles.html
gt;
gt; Under Data Validation, look for 'Select Multiple Items from Dropdown List'
gt;
gt;
gt; MarieB wrote:
gt; gt; I would like to use data validation to populate entries into a cell, however,
gt; gt; I 'd like to be able to enter multiple entries from the list into one cell.
gt; gt; Is this possible?
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;

Hi Debra

Spotted the change - thanks.
--
Mariequot;MarieBquot; wrote:

gt; Hi Debra
gt; The sample file this points to seems to answer a different question, I
gt; cannot find how this allows the input of multiple 'answers' into one cell.
gt;
gt; Saying that, I loved what this sample file does also!
gt; --
gt; Marie
gt;
gt;
gt; quot;Debra Dalgleishquot; wrote:
gt;
gt; gt; You can do this with programming. There's a sample file he
gt; gt;
gt; gt; www.contextures.com/excelfiles.html
gt; gt;
gt; gt; Under Data Validation, look for 'Select Multiple Items from Dropdown List'
gt; gt;
gt; gt;
gt; gt; MarieB wrote:
gt; gt; gt; I would like to use data validation to populate entries into a cell, however,
gt; gt; gt; I 'd like to be able to enter multiple entries from the list into one cell.
gt; gt; gt; Is this possible?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Debra Dalgleish
gt; gt; Excel FAQ, Tips amp; Book List
gt; gt; www.contextures.com/tiptech.html
gt; gt;
gt; gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()