Hover Text Linked to a Data Validation List

Hello All,

I am new to Excel, but I fear I have a question that does not have an answer.

I am currently trying to set up a spreadsheet that will act as a non-conformance log sheet. One of my columns is designated to display the cause of the non-conformance using a 3 digit code but I would like to link each 3 digit code to another cell that will display a longer comment via hovering or clicking on the cell.

My G column is set to pull the cause code from the list I have selected from O1 - O23 via a drop down box (this part I already have set up). After a cause code is selected in G2 I would like to be able to mouse over or select G2 and have it display text that is specific to each cause code.

For example in cell G2 I hit my drop down box and select my cause code "Cu3" (which is linked to cell O14) I would like to be able to mouse over or click cell G2 and have it display "Customer - Damaged Threads".


I imagine I would probably need a macro for such a thing and I am hoping someone has already come up with such a thing.


If I need to describe my ultimate goal better let me know.

Thanks,
Ryan

Hi, im very new to VBA, if i want the same for cell B3-B22 as B2 which part do i amend?

Hi,

Thanks for the reply, im sorry for any inconvenience. I did think it was relevant to this thread as i was using the worksheet and cells from the reply post? I have reposted in a new thread (hopefully in the correct place).