Data Validation

[dan]

Hello all. My question concerns the message box within Excel Data
Validation.

I have 2 cells on OPPOSITE ends of a worksheet which use different
Data Validations. My problem is that both message boxes appear in one
place. I would like each Validation box to appear next to the cell
which is selected. Any ideas?

Thanks. Dan.

 

[Dave Peterson]

Sometimes, you can just show that data|validation input message box and move it
to where you want it.

If you're really unlucky, usually closing (and saving???) the workbook and
reopening will put the input message box back to their original location.

 

[Debra Dalgleish]

Dave's suggestion to close and reopen the workbook should fix the problem.
Usually, if you move one of the data validation message boxes while it's
displayed, all the validation messages will appear in that spot until
you close and reopen the file.

 

[dan]

Dave's suggestion to close and reopen the workbook should fix the problem.
Usually, if you move one of the data validation message boxes while it's
displayed, all the validation messages will appear in that spot until
you close and reopen the file.

Thank you both for the information.

 

[Dave Peterson]

Ahhh.

I just figured that I moved both of my test validation test boxes (kind of
grouped).

 

[Debra Dalgleish]

Don't touch the data validation boxes! And it's the same in Excel 2007,
so I guess it's a feature. <g>

Ahhh.

I just figured that I moved both of my test validation test boxes (kind of
grouped).

 

[Dave Peterson]

I try to keep my grubby fingers off comments and data|validation boxes!

Don't touch the data validation boxes! And it's the same in Excel 2007,
so I guess it's a feature. <g>

 

[dan]

I try to keep my grubby fingers off comments and data|validation boxes!







--

Dave Peterson- Hide quoted text -

- Show quoted text -

LOL. Thanks!