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?

Hello,

I´m trying to print a userform (with a printform command), but
can´t setup it.
Do you know something about that

--
Message posted from http://www.ExcelForum.com

Please,

I kown you are in another discution, but I realy don´t understan
very well how to use its discution group. I have enter in this one an
I thank you so much for any help.

Do you konw something about my last question? "Print userforms

--
Message posted from http://www.ExcelForum.com

"mona001 " skrev i melding
...
Hello,

I´m trying to print a userform (with a printform command), but I
can´t setup it.
Do you know something about that?

Private Sub CommandButton1_Click()
Me.PrintForm
End Sub

HTH. Best wishes Harald