View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pkenchatt@britishlibrary.net is offline
external usenet poster
 
Posts: 7
Default SpinButton & Date Format

I would like to use a SpinButton to change the date value held in
TextBox1. Using the follow code in the SpinUp event procedures works
------------------------------
Private Sub SpinButton1_SpinUp()
TextBox1.Text = Format(CDate(TextBox1.Text) + 1, "dd mm yyyy")
End Sub
------------------------------

But I need to return the date in the form "Monday 21 Dec" with no
year

------------------------------
Private Sub UserForm_Initialize()
TextBox1.Text = Format(Date + 1, "dddd d mmm")
End Sub
------------------------------

I would welcome any advice

Thanks
Phil