Display popup window or comment tag

[JCHuysamer]

Hi Guys and girls

Thanks for all the help to date

I finally completed my Template - but with it being in "testing Mode - Alpha or Beta" (don't know how you clever ppl refer to it) their has been a few requests to make the document easier to use. Sorted out most of it but i am once again stuck.

I have 4 Worksheets (Cover Page, Task Steps, Task Analysis, PTO)

I have a equation on the Task Analysis Worksheet that copy's the text from column A (Task Steps Worksheet) to column B onTask Analysis Worksheet depending on what number is typed into Column A

(ie.:=IF(A4=1,'Task Steps'!$B$12,IF(A4=2,'Task Steps'!$B$13,IF(A4=3,'Task Steps'!$B$14,IF(A4=4,'Task Steps'!$B$15,IF(A4=5,'Task Steps'!$B$16,IF(A4=6,'Task Steps'!$B$17,IF(A4=7,'Task Steps'!$B$18,IF(A4=8,'Task Steps'!$B$19,IF........... and so on)

I need a popup window (similar to the comments popup) to display with the text from column C (Task Steps) corresponding with the he number that was typed in column A on the Task Analysis Worksheet on the Task Analysis Workbook when I select cell C in that same row


Task Steps

task #	task steps	description of step
1	open door	take door handle and turn
2	walk to car	walk down steps to car
3	open car door	put the key in the door and turn to unlock the door

<tbody>
</tbody>

Task Analysis

Column A	Column B	Column C
1	open door	(display in popup when i select the cell- take door handle and turn )
2	walk to car	(display in popup when i select the cell- walk down steps to car )
1	open door	(display in popup when i select the cell- take door handle and turn )

<tbody>
</tbody>

When I put the task # in Column A it copy's the corresponding step to Column B from the previous worksheet
If I select Column C I want the text from Task Steps to display as above