Hello!
I am creating a budget template with many lines and columns. What I would like to do is when a user clicks on a cell they receive an information message about the line. For Example:
CELL A1 CELL B1 CELL C1 CELL D1 CELL E1 CELL F1 CELL G1
SHIP TO PRODUCT PRODUCT CODE COUNTRY VOLUMES SALES BUDGET
CELL A2 CELL B2 CELL C2 CELL D2 CELL E2 CELL F2 CELL G2
ABC FOOD 123 USA 1 100 90
I could freeze the panes but there is a bunch of information in the cells to the left of the actual values. So, I would like to have a helpful pop up window. So, when a user clicks in cell F2, they would receive a pop up window such as...
SHIP TO ABC
PRODUCT FOOD
PRODUCT CODE 123
COUNTRY USA
Since I have many rows I would like this to occur in each row in cells F1 TO F50 with a cell reference to $A2/$B2/$C2/$D2.
So, row 50 would have a pop up window when clicking in a cell F50 with information linked to cell A50 B50 C50 D50
Many thanks in advance for any thoughts. My guess would be VBA code, but I am not savvy enough to write my own.
Joe
I am creating a budget template with many lines and columns. What I would like to do is when a user clicks on a cell they receive an information message about the line. For Example:
CELL A1 CELL B1 CELL C1 CELL D1 CELL E1 CELL F1 CELL G1
SHIP TO PRODUCT PRODUCT CODE COUNTRY VOLUMES SALES BUDGET
CELL A2 CELL B2 CELL C2 CELL D2 CELL E2 CELL F2 CELL G2
ABC FOOD 123 USA 1 100 90
I could freeze the panes but there is a bunch of information in the cells to the left of the actual values. So, I would like to have a helpful pop up window. So, when a user clicks in cell F2, they would receive a pop up window such as...
SHIP TO ABC
PRODUCT FOOD
PRODUCT CODE 123
COUNTRY USA
Since I have many rows I would like this to occur in each row in cells F1 TO F50 with a cell reference to $A2/$B2/$C2/$D2.
So, row 50 would have a pop up window when clicking in a cell F50 with information linked to cell A50 B50 C50 D50
Many thanks in advance for any thoughts. My guess would be VBA code, but I am not savvy enough to write my own.
Joe
