Pop-up Text Box

[k9nny]

Hello everybody,

Let’s say that I have a spreadsheet that represents a calendar; dates across the top and workers names down the side. The spreadsheet is used to record picking discrepancies in our warehouse.

The ‘calendar’ sheet cells are colour coded to denote the reason code, and the detail of the discrepancy is entered into a different worksheet; information like pick location, item number and reason code are entered here into separate columns.

Here is what I am after. I’d like to be able to view the detail of the discrepancy from the calendar sheet, i.e. either click or hover over a colour-coded cell to launch a text box that summarises the detail.

How does that sound?

Thanks, Kenny.

 

[mplees]

Hi Kenny,

One possible approach could be to write some VBA code that adds a comment to each of the relevant cells, and performs a lookup to the source data. A very basic and crude example could be:

Dim vL, vR

vL = Range("G4").Value
vR = Range("A1:B5")
Range("G4").NoteText WorksheetFunction.VLookup(vL, vR, 2, False)

...might give you some ideas on how to do this. If you need any further help, feel free to ask.

Regards,

Mark