Prev: Calculating Sum Series
Next: Problem with subsets for multiple Report Filters in 2007 PivotTabl
From: richard on 21 Apr 2010 02:57
Hi,

I am trying to create a combo box for first time. Have followed instructions
from Debra Dalgleish website, but the combo box will not appear or be
activated when a data validation cell is double clicked. I have also
downloaded the example from the website and again when the cell with data
validation is double clicked nothing happens.
Have I a setting out of place???

Any thoughts

Richard
From: Jacob Skaria on 21 Apr 2010 05:16
Combo or List? ,,Again the dropdown list is seen when you activate the
cell.You dont need to double click

--From menu Data>Validation>
--In settings tab for Validation Critiera select 'List'
--Type as below and hit OK
Yes,No

OR refer a range as which contains Yes and No
=$A$1:$A$2


--
Jacob (MVP - Excel)


"richard" wrote:

> Hi,
>
> I am trying to create a combo box for first time. Have followed instructions
> from Debra Dalgleish website, but the combo box will not appear or be
> activated when a data validation cell is double clicked. I have also
> downloaded the example from the website and again when the cell with data
> validation is double clicked nothing happens.
> Have I a setting out of place???
>
> Any thoughts
>
> Richard
From: richard on 22 Apr 2010 03:38
Jacob

I have the data validation list set up, however I need the ability for
'autocomplete' when users are typing. Therefore I need the matchentry
facility, hence the combo box.

Richard

"Jacob Skaria" wrote:

> Combo or List? ,,Again the dropdown list is seen when you activate the
> cell.You dont need to double click
>
> --From menu Data>Validation>
> --In settings tab for Validation Critiera select 'List'
> --Type as below and hit OK
> Yes,No
>
> OR refer a range as which contains Yes and No
> =$A$1:$A$2
>
>
> --
> Jacob (MVP - Excel)
>
>
> "richard" wrote:
>
> > Hi,
> >
> > I am trying to create a combo box for first time. Have followed instructions
> > from Debra Dalgleish website, but the combo box will not appear or be
> > activated when a data validation cell is double clicked. I have also
> > downloaded the example from the website and again when the cell with data
> > validation is double clicked nothing happens.
> > Have I a setting out of place???
> >
> > Any thoughts
> >
> > Richard
 | 
Pages: 1
Prev: Calculating Sum Series
Next: Problem with subsets for multiple Report Filters in 2007 PivotTabl