I created a DialogBox which has a ListBox on it, when I click on any of the
names which appear in the ListBox and click OK the name is deposited into
the cell as it should be, but, as soon as I scroll down even by one to get a
name which does not appear in the List window (the ListBox displays the
first 20 rows of 120) and click on OK, Excel crashes.

Any ideas??

The list uses a RowSource of Employee_List! A4:B120

Turns out the problem was associated to the code I used for the OK Button.


"Patrick Simonds" wrote in message
...
I created a DialogBox which has a ListBox on it, when I click on any of the
names which appear in the ListBox and click OK the name is deposited into
the cell as it should be, but, as soon as I scroll down even by one to get
a name which does not appear in the List window (the ListBox displays the
first 20 rows of 120) and click on OK, Excel crashes.

Any ideas??

The list uses a RowSource of Employee_List! A4:B120