Show information from list when put cursor to a cell

[cmokasak]

I have about 2,000 importance records (confidential).

Therefore, I am trying to build an interactive excel sheet.

First, I have a list of records (tab 'List'). For example

Category	Options
Sun	Sunglasses
Sun	Hat
Sun	Sun Cream
Sea	Swim Suit
Sea	Snorkeling
Sand	Sunglasses

In a dashboard (tab 'Option'), I have a list of category.

Category

Sun

Sea

Sand

The requirement is: when I put cursor to a cell with word 'Sun' (without click), all options of 'Sun' should show as a list (similar to tab 'Result)'.
Each option should be able to make a link to other tab.

Untitled.png

Please be noted that this should apply only to the dashboard page and MUST NOT impact other tab.

Could anyone help me urgently please?

Thank you very much.
Have a nice day

[Bernie Deitrick]

Short answer: No, you can't do this.

"I put cursor to a cell with word 'Sun' (without click)"

If you click the cell, you could use the worksheet's selection change event to clear your second list's area and populate it with members of the list that match the current cell's value.

[cmokasak]

Could anyone help me with the coding please?

[Bernie Deitrick]

1) Copy this code.
2) Right-Click the sheet tab of sheet "Option"
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Make changes as needed

Please Login or Register  to view this content.

[cmokasak]

Thank you very much for your great work.
Have a nice day

N.B. I have resolved our topic and added a reputation to you.