Textbox data with quotations

[wrobs]

I am using textboxes on a UserForm to populate cells in a worksheet, however, this data needs to be enclosed with quotations once it is in the active cell of the worksheet. I have the following code to put data (Start Date) in cell C3 but how can I get the date to be enclosed with quotations (i.e "10/27/09")

Private Sub txtStartDate_AfterUpdate()
Dim ws As Worksheet
Set ws = Worksheets("FileCreator")
ws.Range("C3").Value = txtStartDate.Value
End Sub

I tried putting the quotations in the Text and/or Value field (textbox properties) but when tabbed, they are highlighted which then requires mousing in between to type in data.

Any ideas?
I am sort of 'green' with VBA so any help is greatly appreciated.

Robert

[mikerickson]

Have you tried changing this line

Please Login or Register  to view this content.

[wrobs]

BINGO!
Thanks a bunch... that works great!