Hi All,
I have two UserForms, each having a ListBox. The ListBox on UserForm1 contains Contractors and the ListBox on UserForm2 contains the jobs that these Contractors do. On the first pass, when I open the form and select a contractor, I get the proper job list in UserForm2, but each time after that, it seems to be one selection behind. For instance If I select Plumber in UserForm1 the first time, I get the Plumbers jobs, but If I select Joiner next time, the Plumbers jobs are still listed. When I then select Electrician the Plumbers jobs are shown.
Can anyone help me please???
Thanks in advance for any help.
Regards,
Bill
I have two UserForms, each having a ListBox. The ListBox on UserForm1 contains Contractors and the ListBox on UserForm2 contains the jobs that these Contractors do. On the first pass, when I open the form and select a contractor, I get the proper job list in UserForm2, but each time after that, it seems to be one selection behind. For instance If I select Plumber in UserForm1 the first time, I get the Plumbers jobs, but If I select Joiner next time, the Plumbers jobs are still listed. When I then select Electrician the Plumbers jobs are shown.
Can anyone help me please???
Thanks in advance for any help.
Regards,
Bill