• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating the cell product code

Nitish Singhal

New Member
I am new to VBA. and need help to create the following code:
1) i want the product of the cell number i.e. if it's cell A1 then product is 1X1, if it's cell B1 then product shall be 2X1, if cell is E5 then product is 5X5 and so on
 
As You wanted ...
Copy next code and select any cell...
You'll get it
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    With ActiveCell
        MsgBox "The Product Of The Cell Number is " & .Column & "X" & .Row
    End With
End Sub
 
Back
Top