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?

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?