date reverts to serial number
 

I have a drop down box in a userform that allows the user to select
from the seven days of the week. These days are stored on a sheet in
this format: dddd - mm/dd/yyyy and appear as such when the user clicks
on the drop down arrow. However once the desired day is selected it
shows the serial version of the date. Any suggestions on a way to set
it show that after the user selects the date it still shows the date
and not the serial

date reverts to serial number
 

You also need to format the linked cell as date
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"stewart" wrote:

I have a drop down box in a userform that allows the user to select
from the seven days of the week. These days are stored on a sheet in
this format: dddd - mm/dd/yyyy and appear as such when the user clicks
on the drop down arrow. However once the desired day is selected it
shows the serial version of the date. Any suggestions on a way to set
it show that after the user selects the date it still shows the date
and not the serial

date reverts to serial number
 

On Sep 9, 6:14 pm, Michael wrote:
You also need to format the linked cell as date
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

"stewart" wrote:
I have a drop down box in a userform that allows the user to select
from the seven days of the week. These days are stored on a sheet in
this format: dddd - mm/dd/yyyy and appear as such when the user clicks
on the drop down arrow. However once the desired day is selected it
shows the serial version of the date. Any suggestions on a way to set
it show that after the user selects the date it still shows the date
and not the serial

i should clarify that once the date is selected the date appears as a
serial while still displayed in the userform. the source is formated
correctly and when i place the value of the drop down box into a cell
it displays as i would like it/ my problem is the in between time
when after the user has selected the date.

date reverts to serial number
 

Have you tried using the DateSerial function?
--
TomThumb


"stewart" wrote:

On Sep 9, 6:14 pm, Michael wrote:
You also need to format the linked cell as date
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

"stewart" wrote:
I have a drop down box in a userform that allows the user to select
from the seven days of the week. These days are stored on a sheet in
this format: dddd - mm/dd/yyyy and appear as such when the user clicks
on the drop down arrow. However once the desired day is selected it
shows the serial version of the date. Any suggestions on a way to set
it show that after the user selects the date it still shows the date
and not the serial

i should clarify that once the date is selected the date appears as a
serial while still displayed in the userform. the source is formated
correctly and when i place the value of the drop down box into a cell
it displays as i would like it/ my problem is the in between time
when after the user has selected the date.

date reverts to serial number
 

On Sep 10, 3:00 am, TomThumb
wrote:
Have you tried using the DateSerial function?
--
TomThumb

"stewart" wrote:
On Sep 9, 6:14 pm, Michael wrote:
You also need to format the linked cell as date
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

"stewart" wrote:
I have a drop down box in a userform that allows the user to select
from the seven days of the week. These days are stored on a sheet in
this format: dddd - mm/dd/yyyy and appear as such when the user clicks
on the drop down arrow. However once the desired day is selected it
shows the serial version of the date. Any suggestions on a way to set
it show that after the user selects the date it still shows the date
and not the serial

i should clarify that once the date is selected the date appears as a
serial while still displayed in the userform. the source is formated
correctly and when i place the value of the drop down box into a cell
it displays as i would like it/ my problem is the in between time
when after the user has selected the date.

Could you please clarify Tom. No I am not using the DateSerial
function and I am afraid to say that I am not familiar with how to use
it.

date reverts to serial number
 

Hello stewart
Use the Change event from your combobox eg:
Private Sub ComboBox1_Change()
With ComboBox1
..Value = Format(.Value, "dddd - mm/dd/yyyy")
End With
End Sub

HTH
Cordially
Pascal

"stewart" a écrit dans le message de news:
...
On Sep 10, 3:00 am, TomThumb
wrote:
Have you tried using the DateSerial function?
--
TomThumb

"stewart" wrote:
On Sep 9, 6:14 pm, Michael wrote:
You also need to format the linked cell as date
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

"stewart" wrote:
I have a drop down box in a userform that allows the user to select
from the seven days of the week. These days are stored on a sheet
in
this format: dddd - mm/dd/yyyy and appear as such when the user
clicks
on the drop down arrow. However once the desired day is selected
it
shows the serial version of the date. Any suggestions on a way to
set
it show that after the user selects the date it still shows the
date
and not the serial

i should clarify that once the date is selected the date appears as a
serial while still displayed in the userform. the source is formated
correctly and when i place the value of the drop down box into a cell
it displays as i would like it/ my problem is the in between time
when after the user has selected the date.

Could you please clarify Tom. No I am not using the DateSerial
function and I am afraid to say that I am not familiar with how to use
it.

date reverts to serial number
 

On Sep 10, 10:34 am, "papou"
wrote:
Hello stewart
Use the Change event from your combobox eg:
Private Sub ComboBox1_Change()
With ComboBox1
.Value = Format(.Value, "dddd - mm/dd/yyyy")
End With
End Sub

HTH
Cordially
Pascal

"stewart" a écrit dans le message de news:
om...

On Sep 10, 3:00 am, TomThumb
wrote:
Have you tried using the DateSerial function?
--
TomThumb

"stewart" wrote:
On Sep 9, 6:14 pm, Michael wrote:
You also need to format the linked cell as date
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

"stewart" wrote:
I have a drop down box in a userform that allows the user to select
from the seven days of the week. These days are stored on a sheet
in
this format: dddd - mm/dd/yyyy and appear as such when the user
clicks
on the drop down arrow. However once the desired day is selected
it
shows the serial version of the date. Any suggestions on a way to
set
it show that after the user selects the date it still shows the
date
and not the serial

i should clarify that once the date is selected the date appears as a
serial while still displayed in the userform. the source is formated
correctly and when i place the value of the drop down box into a cell
it displays as i would like it/ my problem is the in between time
when after the user has selected the date.

Could you please clarify Tom. No I am not using the DateSerial
function and I am afraid to say that I am not familiar with how to use
it.
that did the trick thank you