Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker Lock property
Is there a way to lock the DTPicker so that the value can't be changed? I
want to lock the DTPicker to prevent someone from accidentally making a change to it. I was able to do that for the TextBoxes on the form but the DTPicker does't have a property like that. Is there a way to do that? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker Lock property
Change the DTPicker's Enabled value from True to False. Of course, it will look washed out. If you
don't like that look, then store the Value and reassign it in one or more of the DTPicker's events. HTH, Bernie MS Excel MVP "Ayo" wrote in message ... Is there a way to lock the DTPicker so that the value can't be changed? I want to lock the DTPicker to prevent someone from accidentally making a change to it. I was able to do that for the TextBoxes on the form but the DTPicker does't have a property like that. Is there a way to do that? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
DTPicker Lock property
--If you mean to lock at run time after the initial user selection; then why
not place a hidden text box and once the selection is made transfer that to a text box and make is visible over dtpicker.. --If you mean althrough the user interaction then better place a text box and display date formatted using Format(Date,"dd/m/yyyy") or any format which you would prefer If this post helps click Yes --------------- Jacob Skaria "Ayo" wrote: Is there a way to lock the DTPicker so that the value can't be changed? I want to lock the DTPicker to prevent someone from accidentally making a change to it. I was able to do that for the TextBoxes on the form but the DTPicker does't have a property like that. Is there a way to do that? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DTPicker Bug | Excel Programming | |||
DTpicker | Excel Programming | |||
DTPicker | Excel Programming | |||
Size bug with DTPicker | Excel Programming | |||
set date on dtpicker | Excel Discussion (Misc queries) |