In Excel 2002 using and an InputBox I want to input an ID#, then find that
ID# in a VLOOKUP table, then using the InputBox, enter a score (Points) in
the cell next to (right of) the ID# in the table.
I am trying this to no avail:
' PointsInput Macro
' Macro recorded 1/10/2008 by Barney
ActiveCell.FormulaR1C1 = _
Also, how do I make the Input Box remain active while I loop through 120
ID#'s and Points so that I don't need to continually select a macro button?
Thanks in advance