Hi- need to find out how (if possible) to use data validation but include an
option to select multiple choices in validation list (ie. checkboxes similar
to pivot table options)
--
ccw

Hi,
take a look to Debra Web

http://www.contextures.com/xlDataVal02.html

if this helps please click yes, thanks

"ccw" wrote:

Hi- need to find out how (if possible) to use data validation but include an
option to select multiple choices in validation list (ie. checkboxes similar
to pivot table options)
--
ccw

actually, what I needed was to see if the drop down selections can be check
boxes so I can select more than one option in the validation list. does this
make sense?
--
ccw


"Eduardo" wrote:

Hi,
take a look to Debra Web

http://www.contextures.com/xlDataVal02.html

if this helps please click yes, thanks

"ccw" wrote:

Hi- need to find out how (if possible) to use data validation but include an
option to select multiple choices in validation list (ie. checkboxes similar
to pivot table options)
--
ccw

You can not do what you are asking for with data validation. Data validation
exists in one cell so if it did allow for multiple selections where would it
put the multiple responses. It can not place the values in other cells and
one cell will only hold the one value.
--
HTH...

Jim Thomlinson


"ccw" wrote:

actually, what I needed was to see if the drop down selections can be check
boxes so I can select more than one option in the validation list. does this
make sense?
--
ccw


"Eduardo" wrote:

Hi,
take a look to Debra Web

http://www.contextures.com/xlDataVal02.html

if this helps please click yes, thanks

"ccw" wrote:

Hi- need to find out how (if possible) to use data validation but include an
option to select multiple choices in validation list (ie. checkboxes similar
to pivot table options)
--
ccw

It can be done using DV dropdowns and a bit of event code.

Download a sample workbook from Debra Dalgleish's site.

http://www.contextures.on.ca/excelfiles.html#DV0017


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 08:59:02 -0700, ccw
wrote:

Hi- need to find out how (if possible) to use data validation but include an
option to select multiple choices in validation list (ie. checkboxes similar
to pivot table options)