View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Simonds Patrick Simonds is offline
external usenet poster
 
Posts: 258
Default Very strange ListBox problem

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