Excel VBA Question

[Kim]

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?

 

[Bob Phillips]

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)

 

[mona001]

Hello,

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

 

[mona001]

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

 

[Harald Staff]

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