Excel VBA Question

K

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?
 
B

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)
 
M

mona001

Hello,

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

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
 
H

Harald Staff

mona001 > said:
Hello,

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

Private Sub CommandButton1_Click()
Me.PrintForm
End Sub

HTH. Best wishes Harald
 
Top