Results 1 to 1 of 1
Thread: Data Validation Pop-up boxes
2001-05-01, 06:43 #1
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
Data Validation Pop-up boxes
I have used data validation to ensure entries into certain cells fall between certain values. All works well. However, I would like the pop-up box containing the prompt to pop up in a specific place on the worksheet everytime.
So far I have discovered that if you drag the pop-up to the desired location, it will stay there and all prompts from any validated cell appear in it - as opposed to being in a pop-up near the cell itself.
This would be good enough, but after shutting the sheet, then reloading it, I find the pop-ups return to their old ways, appearing near the cell in question.
I have also noticed that the messages appear in bubbles attached to the Office Assistant should this pesk be open at the time. This is not a problem. I just want the box to stay put when a pop-up appears when using a data validated cell.