Macro VBA Enter Key moves Left , Prompt ,Left, Prompt,Down Right,Right

[wiesele]

Hi
Excel 2016 VBA Macro question

I want to create a Macro Button that controls the movement of my cursor (between entering data) and a 2nd macro.

Example
Start Macro (in any field)
Wait till a value is entered into a field (enter)
Move Left. Wait till a value to the field (enter)
Move Left. Wait till a value to the field (enter)
Move Left. Wait till a value to the field (enter)
Move Left. Wait till a value to the field (enter)

Move Down
Move Right
Move Right
Move Right
Move Right

Repeat.

Move from C5 to D5 to E5 to F5
Move to C6

Stop macro

Thanks
E.W.

 

[wiesele]

I figured it out

Public Sub InputBoxMoveLeft()

Dim strMsg As String
Dim strInputBoxText As String

strInputBoxText = Application.InputBox("Range is 24.8 - 26.8", "TC 224", "0")
ActiveCell = strInputBoxText 'Assign the value of the inputbox to a cell.
ActiveCell.Offset(0, 1).Select

strInputBoxText = Application.InputBox("Range is 6.25 - 6.45", "Port 6.5", "0")
ActiveCell = strInputBoxText 'Assign the value of the inputbox to a cell.
ActiveCell.Offset(0, 1).Select

strInputBoxText = Application.InputBox("Range is 9.9 - 10.1", "TC 10", "0")
ActiveCell = strInputBoxText 'Assign the value of the inputbox to a cell.
ActiveCell.Offset(1, -4).Select


End Sub