How to square a number in VBA excel?

[sylvest]

Hi how to sqUARE A NO. IN vba EXCEL?

[mortgageman]

Not tested, but not much to go wrong with this either

public function sqnum (num2bsquared as double) as double
sqnum=num2bsquared * num2bsquared
end function

Gene, "The Mortgage Man", Klein

[shippey121]

we will need more information on what you are wanting to do,

like where do you get the number from that you are wanting to SQUARE and where do you want the result to be

the code using an input and a message box for the result would be#

Sub squre()
x = 0
x = InputBox("enter number")
z = x * x
MsgBox ("the Squre of " & x & " is " & z)

End Sub

HTH

[Peter_SSs]

.. or perhaps something like this?
Sub Square()
****Selection.Offset(0, 1).Value = Selection.Value ^ 2
End Sub