Instructions within VBA Functions
 

Hi Tom,

The date serial is stored as a number i think. It's alignment i
towards the right side of the cell.

I tried to select a particular cell after that by doing:


*Range("F4").Select*

But still it didn't select the cell :(



Tom Ogilvy Wrote:
The only reason the approach you show would not work (given that th
cell to
be selected is in the activewindow) that I can think of is if you
date
serial is being stored as a string rather than a number.

--
Regards,
Tom Ogilvy

"silvest" wrote in message
...

I defined a function in VBA that converts dates keyed in as YYYYMMD
to
be displayed as DD/MM/YYYY using "DateValue" command as well as the
Left, Mid and Right functions

However, excel will only display the dates in the serial numbers.

After the conversion into serial numbers (before 'end function'),
had
this:


*ActiveCell.Select
Selection.NumberFormat = "dd/mm/yyyy"*

But somehow, it doesn't select that cell to convert into dd/mm/yyyy
format.
I have to manually right click the cell and format it as date.

Is there anyway to do this in VBA ?


--
silvest

------------------------------------------------------------------------
silvest's Profile:
http://www.excelforum.com/member.php...o&userid=14662
View this thread
http://www.excelforum.com/showthread...hreadid=267289


--
silves
-----------------------------------------------------------------------
silvest's Profile: http://www.excelforum.com/member.php...fo&userid=1466
View this thread: http://www.excelforum.com/showthread.php?threadid=26728

Instructions within VBA Functions
 

hi,
get rid of the 2 * 's and it will work. i use that command
all the time.
-----Original Message-----

Hi Tom,

The date serial is stored as a number i think. It's
alignment is
towards the right side of the cell.

I tried to select a particular cell after that by doing:


*Range("F4").Select*

But still it didn't select the cell :(



Tom Ogilvy Wrote:
The only reason the approach you show would not work
(given that the
cell to
be selected is in the activewindow) that I can think of
is if your
date
serial is being stored as a string rather than a number.

--
Regards,
Tom Ogilvy

"silvest" wrote
in message
...

I defined a function in VBA that converts dates keyed
in as YYYYMMDD
to
be displayed as DD/MM/YYYY using "DateValue" command
as well as the
Left, Mid and Right functions

However, excel will only display the dates in the
serial numbers.

After the conversion into serial numbers (before 'end
function'), i
had
this:


*ActiveCell.Select
Selection.NumberFormat = "dd/mm/yyyy"*

But somehow, it doesn't select that cell to convert
into dd/mm/yyyy
format.
I have to manually right click the cell and format it
as date.

Is there anyway to do this in VBA ?


--
silvest

--------------------------------------------------------
----------------
silvest's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=14662
View this thread:
http://www.excelforum.com/showthread...hreadid=267289



--
silvest
----------------------------------------------------------
--------------
silvest's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14662
View this thread:
http://www.excelforum.com/showthread...hreadid=267289

.