Visual basic, form does not show date correctly....

H

Haris

Hello guys, i have created a form using Visual Basic, however i have a
problem, just for presentation reasons problem.

When the form comes up, in order to select a date, the date is shown
correctly, but when the date is selected, then a number is shown note a date.
But after when the data is put into an excel sheet , the date is shown
correctly...
The problem is only on the excel Form that comes up...

thanks in advance...
 
I

it

Hello guys, i have created a form using Visual Basic, however i have a
problem, just for presentation reasons problem.

When the form comes up, in order to select a date, the date is shown
correctly, but when the date is selected, then a number is shown note a date.
But after when the data is put into an excel sheet , the date is shown
correctly...
The problem is only on the excel Form that comes up...

thanks in advance...
Click to expand...

Is it mad because of the order of the list? I'm using military time.
So my list looks like 22,23,0,1,2...,13,14. Wierd though becuase I
don't get a problem until my list gets back to the "2". Meaning my
list works when it's 22,23,0,1 but nothing past "2". Any thoughts??

-BD
 
B

Bob Phillips

You need to format it yourself

Format(the_date,"dd mmm yyyy")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
H

Haris

Were do you mean should we put this code? In VB?

Bob Phillips said:
You need to format it yourself

Format(the_date,"dd mmm yyyy")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
B

Bob Phillips

Yes, in the Visual Basic code you are using with the form.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top