How to make a group of text box visible and unvisible when scrolled on certain textbox in Excel

[msiraj]

Hi,
I am vary new to VBA,

In the Excel Dashboard home page there are seven main textboxes and for each there are 3-5 sub categories, which are link to other sheets and macros
now the requirement from my client is that, when he scroll on textbox it must be highlighted and same time the sub-categories must be visible for that textbox and it must hide when he scroll on another one,

Any help is appreciated

 

[combo]

Scrollable textbox? A listbox or combobox would be much more convenient. The Change event procedure can manage visibility (or contents) of other controls.

combo