VBA Excel List Box - Refresh Problem

[Hasnain]

Hi All

Please find an attached zip file. I have some problems in VBA Excel which I want to rectify.

1) When I change List Box 1 other List Boxes show with respective data.

2) List Box 1 and List Box 2 show their header other not.

3) I have defined Names of all ranges. How Can I use it on VBA Coding?


Please help me.

Thanks in advance.

[Leith Ross]

Hello Hasnain,

Set the RowSource property of each UserForm ListBox to the Named Range you want it to display.

Sincerely,
Leith Ross