Help please with UserForm controls

  • Thread starter Thread starter sa3214
  • Start date Start date
S

sa3214

I am wondering if it is possible to have a textbox displaying the current
system date linked to a spinner control that would allow the date to be
changed.

If this is possible ... and the code not to onerous ... would someone mind
posting the code


Regards and TIA
 
I should have made it clear that I only wish to increase/decrease the date
displayed in the TextBox using the spinner and NOT the system date
 
Something like:

Private Sub SpinButton1_SpinUp()
TextBox1 = Format(CDate(TextBox1) + 1, "d-mmm-yyyy")
End Sub

Modify the format to suit.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform Scroll Bar Doesn't Update in Real time ??? 1
userform textbox returns changeable date 4
One spinner that controls whichever cell I select 2
"Tutorial for Userform Controls?" 2
Create Userform from Worksheet 8
Date showing as numbers in Textbox on Userform 2
change the appearnce of a userform 2
Userform, Calender, Problems with Todays Date 4

Back
Top