Validation Box all in same places

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have found that if I reposition a validation box showing the input message,
all similar validation boxes for ALL columns will show in that same spot.
for example, I moved the box in col CA and all validation box for col B shows
up now in CA. I have about 150 columns with probably 60 validation input
messages that now show up in the wrong spot. Any suggestions other than
manually recreating all. I did try to uncheck the SHOW INPUT MESSAGE, and
then go back and turn it on again, thinking it would reset, but no luck.

Thanks,
Kayabob
 
If you close and reopen your workbook, don't those input message boxes return to
their correct spots?
 
You are right. Thanks for the easy fix.

Dave Peterson said:
If you close and reopen your workbook, don't those input message boxes return to
their correct spots?
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel validation input message not anchored to the cell 1
Data validation won't restrict user input - please help 1
validation list 6
Validate Data Message Box 2
Data Validation Input Message Box Position Frozen 3
Data Validation - Location of input message box 5
Data Validation Error 1
Urgently help needed - dropdown box does not show up 1

Back
Top