| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DT Picker
Hi,
How do I get the value of a DT Picker. For example I select a date 4/1/2005. How do I get 4/1/2005. I want to have two DT picker and compare the value between them. Thank you in advance for help.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DT Picker
If you are talking about the Calendar control then all you do is get its
value property - UserForm1.Calendar1.Value Alok Joshi "Alex Martinez" wrote: Hi, How do I get the value of a DT Picker. For example I select a date 4/1/2005. How do I get 4/1/2005. I want to have two DT picker and compare the value between them. Thank you in advance for help.. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DT Picker
Also to compare try:
datediff("d",UserForm1.Calendar1.Value,UserForm2.C alendar2.Value) the "d" is the day type, this wil return the number of days between the two date, supplied from the calendar objects. Regards "Alok" wrote: If you are talking about the Calendar control then all you do is get its value property - UserForm1.Calendar1.Value Alok Joshi "Alex Martinez" wrote: Hi, How do I get the value of a DT Picker. For example I select a date 4/1/2005. How do I get 4/1/2005. I want to have two DT picker and compare the value between them. Thank you in advance for help.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a Time picker? | Excel Discussion (Misc queries) | |||
| Date Picker | Excel Discussion (Misc queries) | |||
| add date picker | New Users to Excel | |||
| Picker hi-lighing | Excel Discussion (Misc queries) | |||
| DT Picker Control | Excel Programming | |||
Linear Mode
