need a macro

[JasonLevan]

I need a macro that will have a imput box to imput item numbers, i need it to repeat itself until i type the word done in the imput box.

Can anyone help

 

[pbaldy]

This is a duplicate thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=204483

You should have just posted a follow-up question there. Just put your InputBox into a variable, and then test:

VariableName = InputBox(...)

If VariableName = "Done" Then
  Exit Sub
Else
  ActiveCell.FormulaR1C1 = VariableName 
End If