LOL isn't that what I posted yesterday? Anyway, glad to hear it worked
out.


Thx,
JP


On Mar 22, 4:02*pm, ryguy7272
wrote:
Eureka! *I got it; it just had to be inside the sub that was identified with
the ComboBox!! *Here is the solution:

Private Sub ComboBox1_Change()
* * * * If ComboBox1.Text < "" Then
* * * * ComboBox1.Text = Format(CDate(Cells(2, 13).Text), "mm/dd/yyyy")
* * * * End If
* * * * 'etc......

End Sub

Thanks for the help everyone, especially JP!! *Thanks for being patient and
pushing me in the right direction!! *

Cheers,
Ryan--

--
RyGuy