Re: Data Validation: Choice list does not appear

xl97 had a problem with data|validation cells that were above the windows|freeze
panes line (but I think that the down arrow still appeared)--and it was fixed in
xl2k.

And I think there have been posts that Data|Validation can get flakey when used
with merged cells. I believe the "Fix" was to delete the row and insert a new
row and reapply everything there (formulas/text/formatting).

I don't have a good answer for you.

Sorry.

Elodie wrote:
>
> Thank Dave to have answered so quickly. This did not solve my issue but
> thanks to you I have additional information:
>
> The in-cell dropdown" is checked.
>
> I noticie that cell with data validation do not work in all the worksheet,
> the validation data work perfectly in the other other worksheets of the same
> excel document.
> The worksheet is not protected.
>
> Do you have any idea of the format or other set up that may have an impact?
>
> Elodie
> "Dave Peterson" wrote:
>
> > I'd try:
> > Select the cell
> > data|Validation
> > Check the Settings tab to make sure "in-cell dropdown" is checked.
> >
> > If it is, then I'd try stepping through all the tabs in the data|validation and
> > compare them to the same settings in a cell that works.
> >
> > Elodie wrote:
> > >
> > > I use to use the validation data and I am face with a issue I never had:
> > > I have file using validation data (base on a list using named cells) I send
> > > this file to someone and when he send it to be back the choices lists do not
> > > appear anymore. If I enter a value that is not is the list I have the error
> > > messag which is correct
> > > But the small arrow a the right of the cell does not appear and I am not
> > > able to select value.
> > >
> > > I guess an option has been turn on or off. Please Help me! (the person I
> > > have send the file may not help me, he does not know if he has done something
> > > or not :-( )
> > >
> > > Elodie
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson
.

Relevant Pages

  • Is this a feature new to Excel 2002?
    ... When a certain cell is made active, a down arrow appears ... for the list from another worksheet in the book. ... to be an ActiveX control, a form control, there's no code ...
    (microsoft.public.excel.programming)
  • RE: Need macro to move to first blank cell in column
    ... If you want to record the macro then Before you do the down arro operation ... cell and not absolute. ... will be copied and pasted from another worksheet. ... Press right arrow key once to move to col B. ...
    (microsoft.public.excel.misc)
  • Re: end of worksheet problem
    ... Select everything beyond Q742 (ctrl shift down arrow) ... > Is there a way to reset the end of a worksheet? ... There is nothing visible in that cell. ...
    (microsoft.public.excel.worksheet.functions)
  • How do I use my arrow buttons to move cells
    ... and when I use my arrow buttons it scroll my worksheet up ... and down, left and right, instead of moving to the cell in selected direction. ...
    (microsoft.public.excel.misc)
  • RE: Dollar/Euro/Pound Excel macro
    ... hopefully it will be easier for you to maintain/alter, if your worksheet ... like "BH1", with full cell address. ... the sheet with proper results based on the location of the paste action you ... there is one Workbook code module that is used to handle events at the ...
    (microsoft.public.excel.worksheet.functions)