ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help Text in an Excel 2003 or 2007 Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/192265-help-text-excel-2003-2007-worksheet.html)

nicklynne

Help Text in an Excel 2003 or 2007 Worksheet
 
I designed a worksheet in Excel 2003 to be used by multiple users. When the
users click on a cell, a small box pops up that reminds them of pertinent
information needed to complete that cell correctly. I now have Excel 2007
installed and can't find a way to update the contents of the pop-up "hint"
box, since the original contents are now outdated. Please help! This is
driving me crazy!

Ron de Bruin

Help Text in an Excel 2003 or 2007 Worksheet
 
I think you are looking for Datavalidation

In 2007 you find it here
On the Data tab in the Data tools group


See also
http://www.rondebruin.nl/0307commands.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"nicklynne" wrote in message ...
I designed a worksheet in Excel 2003 to be used by multiple users. When the
users click on a cell, a small box pops up that reminds them of pertinent
information needed to complete that cell correctly. I now have Excel 2007
installed and can't find a way to update the contents of the pop-up "hint"
box, since the original contents are now outdated. Please help! This is
driving me crazy!


nicklynne

Help Text in an Excel 2003 or 2007 Worksheet
 
That's it! You are awesome!! Thank you so much!!

"Ron de Bruin" wrote:

I think you are looking for Datavalidation

In 2007 you find it here
On the Data tab in the Data tools group


See also
http://www.rondebruin.nl/0307commands.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"nicklynne" wrote in message ...
I designed a worksheet in Excel 2003 to be used by multiple users. When the
users click on a cell, a small box pops up that reminds them of pertinent
information needed to complete that cell correctly. I now have Excel 2007
installed and can't find a way to update the contents of the pop-up "hint"
box, since the original contents are now outdated. Please help! This is
driving me crazy!



Ron de Bruin

Help Text in an Excel 2003 or 2007 Worksheet
 
If you use it often then add this option to the QAT

Right click on Datavalidation On the Data tab in the Data tools group
and choose Add to QAT bar




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"nicklynne" wrote in message ...
That's it! You are awesome!! Thank you so much!!

"Ron de Bruin" wrote:

I think you are looking for Datavalidation

In 2007 you find it here
On the Data tab in the Data tools group


See also
http://www.rondebruin.nl/0307commands.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"nicklynne" wrote in message ...
I designed a worksheet in Excel 2003 to be used by multiple users. When the
users click on a cell, a small box pops up that reminds them of pertinent
information needed to complete that cell correctly. I now have Excel 2007
installed and can't find a way to update the contents of the pop-up "hint"
box, since the original contents are now outdated. Please help! This is
driving me crazy!




All times are GMT +1. The time now is 07:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com