| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help please with UserForm controls
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ooops - Help please with UserForm controls
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 "sa3214 @eclipse.co.uk" <sa3214<REMOVE wrote in message s.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ooops - Help please with UserForm controls
Something like:
Private Sub SpinButton1_SpinUp() TextBox1 = Format(CDate(TextBox1) + 1, "d-mmm-yyyy") End Sub Modify the format to suit. -- Vasant "sa3214 @eclipse.co.uk" <sa3214<REMOVE wrote in message s.com... 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 "sa3214 @eclipse.co.uk" <sa3214<REMOVE wrote in message s.com... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ooops - Help please with UserForm controls
Thank you very much ... works a charm
Life is wonderful again "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Something like: Private Sub SpinButton1_SpinUp() TextBox1 = Format(CDate(TextBox1) + 1, "d-mmm-yyyy") End Sub Modify the format to suit. -- Vasant "sa3214 @eclipse.co.uk" <sa3214<REMOVE wrote in message s.com... 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 "sa3214 @eclipse.co.uk" <sa3214<REMOVE wrote in message s.com... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ooops - Help please with UserForm controls
Some people are easy to please ... :)
You're most welcome! -- Vasant "sa3214 @eclipse.co.uk" <sa3214<REMOVE wrote in message s.com... Thank you very much ... works a charm Life is wonderful again "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Something like: Private Sub SpinButton1_SpinUp() TextBox1 = Format(CDate(TextBox1) + 1, "d-mmm-yyyy") End Sub Modify the format to suit. -- Vasant "sa3214 @eclipse.co.uk" <sa3214<REMOVE wrote in message s.com... 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 "sa3214 @eclipse.co.uk" <sa3214<REMOVE wrote in message s.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting a handle on Userform controls | Excel Programming | |||
| Hyperlinks from UserForm Controls | Excel Programming | |||
| UserForm Controls References | Excel Programming | |||
| Add controls to UserForm | Excel Programming | |||
| What order does VBA look at userform controls? | Excel Programming | |||
Linear Mode
