Data Validation
 

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.

Data Validation
 

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

Data Validation
 

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

Data Validation
 

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.

Data Validation
 

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

Data Validation
 

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

Data Validation
 

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

Data Validation
 

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!