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;
- Apr 21 Sat 2007 20:37
Data Validation
close
全站熱搜
留言列表
發表留言