Hi

I am trying to create a ListBox that displays the results of a search from a results sheet. The user can then select the set of results to view and these are displayed on a form that can be printed, e-mailed, etc.

To do this the entire row of each search result is copied and then pasted into the next blank row in a blank section of Sheet 1 and this is then used as the row source for the list box. I use 5 columns in the ListBox and have the ControlSource linked to cell Q38 on Sheet1. The ListBox is set to single select.

The problem is when I set the BoundColumn = 1 (as I require the report number as the Lookup_value in a VLookUp formula) the ListBox will not select the entry. This can sometimes work (especially is I reboot the computer) but most of the time I just get a dotted box around the selected entry (instead of the entry all going blue) and the selection radio button does not select.

If I change the BoundColumn = 2 to 5 then it works properly, but it will not work if I change it back to 1???

I must admit that it looks as though something is running or looping somewhere but I cannot see where and don't understand why it works ok with the other boundcolumns.

I am quite new to Excel Vb and I use the internet copy/ paste method of writing so appologies for obvious errors....

Thanks

John