Data validation input message - always in the same area of the page?

[2funny4words]

I have multiple data validations with input messages. For the new user, this is handy, but for the person that does this a lot, they get in the way. When I open the sheet, I can move one message to the side of the page and the rest of them come up at the same spot but when I save, exit, and reopen, the message comes up beside the cell and I would like it to always stay to the side of the page.

Any suggestions?

Thanks

[karan]

Hi,

Can you attach the file? It is a little difficult to understand your requirement.

--Karan--

[Leith Ross]

Hello 2funny4words,

The Data Validation messages are ToolTip windows. These windows are created when the Data Validation object is called he first time. Because of this behavior, no position information is retained when you close and save the workbook. I don't know of any workarounds for this.

[2funny4words]

Thanks Leith,

Is there a way to turn off all validation tips with a macro?

[Leith Ross]

Hello 2funny4words,

Here is a macro to turn off all the Data Validation messages on the active worksheet.

Please Login or Register  to view this content.

[2funny4words]

Leith,

Thanks. If I wanted to show them, could I just have a command button that would show the messages until the sheet was closed? What would I have to do to make that work? Just run a different macro with "false" changed to "true"? Would that work or would I just confuse the computer? And am I confusing macros with codes?

[Leith Ross]

Hello 2funny4words,

You can use this macro to turn the Validation back on. Since it is a separate macro, you can attach it to a different button or call from code when you need it.

Please Login or Register  to view this content.

[2funny4words]

Leith, thanks for your help so far.

Everytime that I try to run the code to turn off validation hints, it wants to load my computer down and usually kicks me unceremoniously out of excel.

What I was going to do was to have a TURN OFF HINTS cmd button and a TURN ON HINTS cmd button with each running the corresponding codes. So far I have just messed with running the TURN OFF one and have yet to get it to turn them off.

Thanks again

[Leith Ross]

Hello 2funny4words,

If you post your workbook, I can review what you done so far. I'll fix any mistakes that I find. I am using Excel 2003.

[2funny4words]

Here is the file. Let me know what you find so that I know what I did wrong so that it won't happen again


Thanks

[johnywhy]

Everytime that I try to run the code to turn off validation hints, it wants to load my computer down and usually kicks me unceremoniously out of excel.

That's because the code suggested above, to turn off validation hints on every single cell in the workbook is unnecessary and a resource-drain

What I was going to do was to have a TURN OFF HINTS cmd button and a TURN ON HINTS cmd button with each running the corresponding codes

That's a great idea. It's only necessary to just turn on and off hints for the ACTIVE CELL, since Excel only displays hints for the active cell anyway. Hints for other cells are not visible.

Create a keystroke which calls:

Please Login or Register  to view this content.

I'll leave it to you to figure out how to assign that to a keystroke.