Kim,

Why not use InputBox to accept the value and then store that in the
worksheet cell instead of a MsgBox?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Kim" wrote in message
...
I have a message box that indicates that if a value is =
0, that the user will receive a message box that indicates
a quantity is required. In my spreadsheet, I have a
column for quantity and this column is part of a formula
wherein the next column calcs the total. How can I have
the user placed in the quantity cell once they click on OK
in my message box?