J
Jo
Hi, I am learning some basic VBA in Excel. I know that using inout boxes
is not the best way to input multiple cells, but as I said I am playing with
VBA.
The following code takes me through cells on a single row and allows me to
enter some data.
What I cannot work out is having enjtered data into H7 , how do I then
switch to A8 and start the code again.
Would appreciate some help if someone has a few minutes.
Many thanks
Jo
CallCost = InputBox("Enter the cost of the call")
Range("A7:H7").Select
Range("A7").Select
ActiveCell.FormulaR1C1 = TelephoneNumber
Range("B7").Select
ActiveCell.FormulaR1C1 = CallDate
Range("C7").Select
ActiveCell.FormulaR1C1 = CallTime
Range("D7").Select
ActiveCell.FormulaR1C1 = Duration
Range("E7").Select
ActiveCell.FormulaR1C1 = Description
Range("F7").Select
ActiveCell.FormulaR1C1 = CallType
Range("G7").Select
ActiveCell.FormulaR1C1 = TimeBand
Range("H7").Select
ActiveCell.FormulaR1C1 = CallCost
is not the best way to input multiple cells, but as I said I am playing with
VBA.
The following code takes me through cells on a single row and allows me to
enter some data.
What I cannot work out is having enjtered data into H7 , how do I then
switch to A8 and start the code again.
Would appreciate some help if someone has a few minutes.
Many thanks
Jo
CallCost = InputBox("Enter the cost of the call")
Range("A7:H7").Select
Range("A7").Select
ActiveCell.FormulaR1C1 = TelephoneNumber
Range("B7").Select
ActiveCell.FormulaR1C1 = CallDate
Range("C7").Select
ActiveCell.FormulaR1C1 = CallTime
Range("D7").Select
ActiveCell.FormulaR1C1 = Duration
Range("E7").Select
ActiveCell.FormulaR1C1 = Description
Range("F7").Select
ActiveCell.FormulaR1C1 = CallType
Range("G7").Select
ActiveCell.FormulaR1C1 = TimeBand
Range("H7").Select
ActiveCell.FormulaR1C1 = CallCost