Just set the control source property to Sheet1!C2

you don't need a macro.

--
Regards,
Tom Ogilvy

"Peter" wrote in message
...
Hi,

I have written a User Form in VBA (Excel 97). This form contains a
ComboBox and the data for this ComboBox (a series of dates is
contained in sheet 2 column A.)

I have the Row Source as Sheet2!A1:A95 and this appears to be OK when
I test it - the selected dates show in the ComboBox (Although the date
then changes to a 5 digit number)

What I haven't worked out what to do is how to tell VBA that the date
I select in the ComboBox is to be written to Sheet1 cell C2. The code
so far is:

Range("C2").Select
Selection = Clear
Range("C2").Select
Selection = ???????

What needs to go on the last line to copy the selected date into cell
C2?

Any suggestions would be very much appreciated.


--
Cheers

Peter

Remove the INVALID to reply