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.

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.

dan wrote:

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

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 wrote:
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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

On Feb 20, 11:57 am, Debra Dalgleish
wrote:
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 wrote:
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.

--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html

Thank you both for the information.

Ahhh.

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

Debra Dalgleish wrote:

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 wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

--

Dave Peterson

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

Dave Peterson wrote:
Ahhh.

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

Debra Dalgleish wrote:

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 wrote:

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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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

Debra Dalgleish wrote:

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

Dave Peterson wrote:
Ahhh.

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

Debra Dalgleish wrote:

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 wrote:

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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

--

Dave Peterson

On Feb 20, 1:28 pm, Dave Peterson wrote:
I try to keep my grubby fingers off comments and data|validation boxes!





Debra Dalgleish wrote:

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

Dave Peterson wrote:
Ahhh.

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

Debra Dalgleish wrote:

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 wrote:

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.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

--

Dave Peterson- Hide quoted text -

- Show quoted text -

LOL. Thanks!