Please share your file mentioning all your requirements..I'll try..
On 7/8/13, srsev6 srs...@gmail.com wrote:
Thank you Enrique. How do I set this up in a code to be able to use in a
command button?
I am familiar with codes in visual basic but not an expert by any means in
writing them.
Thanks for your help Enrique. I have attached the file. In column D
Forecast_Date is the column I want to apply the code to. I have added a
command button I would like to click on to have the code run. If you
double click in a cell under column D you will see there is a date
stamp. No
try this
Sub sample()
Dim cl As Range
For Each cl In Range(d2:d Range(d1048576).End(xlUp).Row)
cl.NumberFormat = @
cl.Value = Application.WorksheetFunction.Text(cl.Value, dd mmm
)
Next
End Sub
see if it helps
On Thu, Jul 11, 2013 at 9:43 PM, srsev6
Thanks Ashish but the dates don't always fall in column D and are not
always just two columns.
How can I change this portion to search the entire sheet? I tried several
options to no avail.
For Each cl In Range(d2:d Range(d1048576).End(xlUp).Row)
On Thursday, July 11, 2013 11:47:18
Try this, this will search a whole used range in sheet, that will be
very slow if you have a big data
*Private Sub CommandButton1_Click()**
**Dim Rng As Range**
**For Each Rng In ActiveSheet.UsedRange**
**If IsDate(Rng.Value) Then Rng.Value = Format(Rng.Value, dd
mmm )**
WOW!! Look at all these wonderful people coming to my aid. Thank you all
so much for your help. DP this formula worked well except that it put a
1/0/1900
date in all my blank cells. I used part of Ashish's formulas to keep that
from happening and now your code works perfectly.
Private
You're welcome,
We're happy to hear that your problem solved.
But we have one problem here, 1/0/1900 is not a date, we will never meet
that case in real world
If i ask to you, What month before January ? That should be December,
and that month is 12 not Zero ;-)
Rgds,
[dp]
Pada 12/07/2013
Thank you Enrique. How do I set this up in a code to be able to use in a
command button?
I am familiar with codes in visual basic but not an expert by any means in
writing them.
On Wednesday, July 3, 2013 7:15:00 PM UTC-5, Enrique Martin wrote:
you can use = text(cell,dd mmm ),
you can use = text(cell,dd mmm ), this will give time in text format.
On Thu, Jul 4, 2013 at 3:17 AM, srsev6 srs...@gmail.com wrote:
Hi all,
I have already posted this once but can not locate it so I apologize for
the duplicate post.
I hope someone can answer my question. I run