Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The input box routine below does exactly what I want it to - but only on the
first line. I want to modify it so it works on every row. The cell references of b, j & K remain the same but the line reference varies. How do I set it up so it knows what line it's on? I'm a newbie so some extra explanation is helpful. Thanks! ActiveSheet.Unprotect Range("b63").Select ActiveCell = "x" mynum = Application.InputBox("Payment including Adj") Range("j63").Value = mynum mynum = Application.InputBox("Enter total overpayment remaining") Range("k63").Value = mynum ActiveSheet.Protect |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
InputBox Help | Excel Discussion (Misc queries) | |||
InputBox | Excel Discussion (Misc queries) | |||
InputBox | Excel Programming | |||
Inputbox and Application.InputBox | Excel Programming | |||
inputbox | Excel Programming |