View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SOS[_39_] SOS[_39_] is offline
external usenet poster
 
Posts: 1
Default Date format from UserForm


Hi All,

I have a very simple UserForm with 4 textboxes and an OK Button on it.

One of the textboxes is for a date which is inputted to the sheet on
clicking OK with the following code:

Private Sub cmdOK_Click()

ActiveCell.Value = tbxDate.Value
ActiveCell.Offset(0, 1).Value = tbxSupplier.Value
ActiveCell.Offset(0, 2).Value = tbxInvoiceTotal.Value
ActiveCell.Offset(0, 3).Value = tbxExtras.Value

End Sub

My difficulty is that if the date is put into the form in the format
dd/mm/yyyy the above code puts it into the active cell in that format.
But I really want the format to be dd-mmm-yyyy. Even if after the form
has been used I try to apply that format to the cell it remains as
dd/mm/yyyy.

If I input the date on the actual sheet as dd/mm/yyyy the format
changes to dd-mmm-yyyy.

Any advice wold be appreciated

Seamus


--
SOS
------------------------------------------------------------------------
SOS's Profile: http://www.excelforum.com/member.php...fo&userid=5406
View this thread: http://www.excelforum.com/showthread...hreadid=513168