Solved: How to activate the cells by using VBA

[clif]

How to activate the cells in Column B by using VBA! :banghead:

I need to press enter in each cells in column A so that the Monday, Tuesday ,... will shown be in column B. I attached the files to you. Please help me!

[patel]

put in B3
=DAY(A3)

[Bob Phillips]

Try using

=TEXT(A2,"dddd")

[clif]

Both methods are useful but i still want to use the method like pressing the "enter" in column A to activate the formula for later development. Any Vba code to do that? Thanks!

[patel]

can you explain why ?

[Bob Phillips]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 Then

If IsDate(Target.Value) Then

Target.Offset(0, 1).Value = Format(Target.Value, "dddd")
End If
End If
End Sub

[clif]

I use data for pivot table and need the sort by date!
But the data is shown as 1/1/2012. 12/1/2012. 13/1/2012

What I want is 1/1/2012. 2/1/2012 3/1/2012

What should I do ? Thank you. Urgent!

[Bob Phillips]

What sort, I don't recall that being mentioned earlier. And if so urgent, how come it took you 11 days to respond?

[clif]

I know how to solve it，thank you!👍
It just enter 1 into one cell and then copy.then paste as value and by product in column of date.