Display popup window or comment tag

JCHuysamer

New Member
Joined
Nov 3, 2015
Messages
43
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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]task #[/TD]
[TD]task steps[/TD]
[TD]description of step[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]open door[/TD]
[TD]take door handle and turn[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]walk to car[/TD]
[TD]walk down steps to car[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]open car door[/TD]
[TD]put the key in the door and turn to unlock the door[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Task Analysis
[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]open door[/TD]
[TD](display in popup when i select the cell- take door handle and turn )[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]walk to car[/TD]
[TD](display in popup when i select the cell- walk down steps to car )[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]open door[/TD]
[TD](display in popup when i select the cell- take door handle and turn )[/TD]
[/TR]
</tbody>[/TABLE]

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

:banghead:
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Forum statistics

Threads
1,223,236
Messages
6,170,917
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top