Hi
where is problem with VBA code?i dont know why i got error and tell it is incorrect
Create a subroutine called AddNumbersB that asks the user for a number, adds that number to the value in the active cell, then places the result in a cell that is 3 rows up and two columns right of the active cell.
Sub AddNumbersB()
Dim x As Double
x = InputBox("input your number:")
ActiveCell.Value = x
ActiveCell.Offset(-3, 2).Value = x
End Sub
where is problem with VBA code?i dont know why i got error and tell it is incorrect
Create a subroutine called AddNumbersB that asks the user for a number, adds that number to the value in the active cell, then places the result in a cell that is 3 rows up and two columns right of the active cell.
Sub AddNumbersB()
Dim x As Double
x = InputBox("input your number:")
ActiveCell.Value = x
ActiveCell.Offset(-3, 2).Value = x
End Sub