Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Spinbutton to change a date
I been looking but I cannot find out how to change a date in a textbox using a spinbutton. I appreciate your help on this matter.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Spinbutton to change a date
Make sure that you put a date string in the textbox on itiliaisation, and
this spin code will work it Private Sub SpinButton1_SpinUp() TextBox1.Text = Format(CDate(TextBox1.Text) + 1, "dd mmm yyyy") End Sub Private Sub SpinButton1_SpinDown() TextBox1.Text = Format(CDate(TextBox1.Text) - 1, "dd mmm yyyy") End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Gheezer" wrote in message ... I been looking but I cannot find out how to change a date in a textbox using a spinbutton. I appreciate your help on this matter. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Spinbutton to change a date
That did the trick. Thank you very much.
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Spinbutton to change a date
You are more than welcome.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Gheezer" wrote in message ... That did the trick. Thank you very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Substitute for OLE SpinButton? | Excel Discussion (Misc queries) | |||
Spinbutton | New Users to Excel | |||
Spinbutton | Excel Discussion (Misc queries) | |||
Spinbutton sorting | Excel Programming | |||
SpinButton Rounding Up | Excel Programming |