Thanks I'll give them a go!
--
Zani
(if I have posted here, I really am stuck!)



"JakeyC" wrote:

To select an entry in the listbox, use something like:

ListBox1.Value = Range("B1").Value 'where B1 is the cell you stored the
previous selection in. This might activate the Click event so turn
Events off if need be with Application.EnableEvents = False.

As for the dates, the only workaround I can think of is to store them
as text format in the destination cells.