ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pop up box with a formula (https://www.excelbanter.com/excel-discussion-misc-queries/124846-pop-up-box-formula.html)

japc90

Pop up box with a formula
 
I have a worksheet that links to another worksheet within the same
workbook. Each cell with a data in it on the first worksheet is showing
a percentage. This percentage comes from the sum of two cells on the
other worksheet divided by another number.

My question: is there a way to have a pop up box of some sort show the
sum of the two cells that is generating the percentage so that those
using the spreadsheet would know what number was generating the
percentage shown.

Thank you for any assistance.


CLR

Pop up box with a formula
 
1-The cell on Sheet1 can be actually the formula retrieving the data from
Sheet2.....this formula will show up in the formula box when the cell is
selected.
2-You could hand-type the information you wnat in a CommentBox attached to
each cell.

hth
Vaya con Dios,
chuck, CABGx3



"japc90" wrote:

I have a worksheet that links to another worksheet within the same
workbook. Each cell with a data in it on the first worksheet is showing
a percentage. This percentage comes from the sum of two cells on the
other worksheet divided by another number.

My question: is there a way to have a pop up box of some sort show the
sum of the two cells that is generating the percentage so that those
using the spreadsheet would know what number was generating the
percentage shown.

Thank you for any assistance.




All times are GMT +1. The time now is 04:28 PM.

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