software

Me again,
A few items:
1) I have plugged this into VB to deny print unless user has selected valid
info from dropdowns:

Private Sub Workbook_BeforePrint_(Cancel As Boolean)
Cancel As Boolean
Cancel = IsEmpty(ShippingRequestForm)(W11, W13, B10, B14, B18, B23,
B37, D37, N37)

Needless to say, ain't workin' amp; I know nada about VB but trying! Where did
I muck this up at?

2)I have 2 cells with DV (W11 amp; W13). Trying to make it so user can not
bypass these without choosing from dropdowns. Formula works:
(=IF($W$13=quot;Prepaid,Collectquot;,quot;okayquot;,quot;Invalidquot;). I can still tab right
through it. If I type anything other than, the error message does work
though. What do I need to add? Additional nested function? Or seperate
formula all together?

3)Dynamic DV list, @ $D$37 for quot;Descriptionquot;, want same quot;IsEmptyquot; rule also
with the ability for me to nest a list of invalid entries (quot;Documentsquot;,
quot;Docsquot;, quot;Giftquot; etc) resulting in error message.
Thx for the email Debra. Gord, Dave et al have been above and beyond. Feel
like I've attended an XL seminar!
Hey Gord, after these my (Your!) beloved Shipping Request Form will be done.
I'll send a copy to you for Xmas! LOL

Thx


quot;cjtj4700quot; gt; wrote in message
...
gt; Me again,
gt; A few items:
gt; 1) I have plugged this into VB to deny print unless user has selected
valid
gt; info from dropdowns:
gt;
gt; Private Sub Workbook_BeforePrint_(Cancel As Boolean)
gt; Cancel As Boolean
gt; Cancel = IsEmpty(ShippingRequestForm)(W11, W13, B10, B14, B18, B23,
gt; B37, D37, N37)
gt;
gt; Needless to say, ain't workin' amp; I know nada about VB but trying! Where
did
gt; I muck this up at?

Guessing here

Private Sub Workbook_BeforePrint_(Cancel As Boolean)
Cancel = Application.COUNTA(Worksheets(quot;ShippingRequestForm quot;).Range( _
quot;W11, W13, B10, B14, B18, B23, B37, D37, N37quot;))
End Sub

gt; 2)I have 2 cells with DV (W11 amp; W13). Trying to make it so user can not
gt; bypass these without choosing from dropdowns. Formula works:
gt; (=IF($W$13=quot;Prepaid,Collectquot;,quot;okayquot;,quot;Invalidquot;). I can still tab right
gt; through it. If I type anything other than, the error message does work
gt; though. What do I need to add? Additional nested function? Or seperate
gt; formula all together?

Don't you just assume Invalid then? Is that wrong? You could use the
BeforeClose to trap these fileds,a nd if not filled, don't let them close.

gt; 3)Dynamic DV list, @ $D$37 for quot;Descriptionquot;, want same quot;IsEmptyquot; rule
also
gt; with the ability for me to nest a list of invalid entries (quot;Documentsquot;,
gt; quot;Docsquot;, quot;Giftquot; etc) resulting in error message.
gt; Thx for the email Debra. Gord, Dave et al have been above and beyond. Feel
gt; like I've attended an XL seminar!
gt; Hey Gord, after these my (Your!) beloved Shipping Request Form will be
done.
gt; I'll send a copy to you for Xmas! LOL

Don't understand about nested invalid entries.
Thx Bob.

The code still doesn't work but I didn't expect it to as I know nothing
about applying my specific info to these helpful codes. I may forget about
that if I can get the other formulas to work. Doing that would give me the
same result: a properly completed form.
Regarding item #2, blank is not allowed. They must specify whether the
shipment is quot;Businessquot; or quot;Personalquot; (W11) amp; quot;Prepaidquot; or quot;Collectquot; (W13).
Internal compliance on this is wasting tons of labor hours (dozens of
incorrect / incomplete forms per day).

Item #3 - I tend to use incorrect terms. Sorry. I need an error message if a
user attempts to type 5 specific descriptions that frequently arrive in my
traffic dept. (Intl. shipments do not allow quot;Documentquot; or quot;Giftquot; as the
description. Must be more specific, quot;Proposalsquot; or quot;Fruitcake sent as giftquot;
etc.). Do dynamic ranges not recognize un-checking quot;Ignore blankquot;? Or does
this work hand in hand with a formula?

Thx

quot;Bob Phillipsquot; wrote:

gt;
gt; quot;cjtj4700quot; gt; wrote in message
gt; ...
gt; gt; Me again,
gt; gt; A few items:
gt; gt; 1) I have plugged this into VB to deny print unless user has selected
gt; valid
gt; gt; info from dropdowns:
gt; gt;
gt; gt; Private Sub Workbook_BeforePrint_(Cancel As Boolean)
gt; gt; Cancel As Boolean
gt; gt; Cancel = IsEmpty(ShippingRequestForm)(W11, W13, B10, B14, B18, B23,
gt; gt; B37, D37, N37)
gt; gt;
gt; gt; Needless to say, ain't workin' amp; I know nada about VB but trying! Where
gt; did
gt; gt; I muck this up at?
gt;
gt; Guessing here
gt;
gt; Private Sub Workbook_BeforePrint_(Cancel As Boolean)
gt; Cancel = Application.COUNTA(Worksheets(quot;ShippingRequestForm quot;).Range( _
gt; quot;W11, W13, B10, B14, B18, B23, B37, D37, N37quot;))
gt; End Sub
gt;
gt; gt; 2)I have 2 cells with DV (W11 amp; W13). Trying to make it so user can not
gt; gt; bypass these without choosing from dropdowns. Formula works:
gt; gt; (=IF($W$13=quot;Prepaid,Collectquot;,quot;okayquot;,quot;Invalidquot;). I can still tab right
gt; gt; through it. If I type anything other than, the error message does work
gt; gt; though. What do I need to add? Additional nested function? Or seperate
gt; gt; formula all together?
gt;
gt; Don't you just assume Invalid then? Is that wrong? You could use the
gt; BeforeClose to trap these fileds,a nd if not filled, don't let them close.
gt;
gt; gt; 3)Dynamic DV list, @ $D$37 for quot;Descriptionquot;, want same quot;IsEmptyquot; rule
gt; also
gt; gt; with the ability for me to nest a list of invalid entries (quot;Documentsquot;,
gt; gt; quot;Docsquot;, quot;Giftquot; etc) resulting in error message.
gt; gt; Thx for the email Debra. Gord, Dave et al have been above and beyond. Feel
gt; gt; like I've attended an XL seminar!
gt; gt; Hey Gord, after these my (Your!) beloved Shipping Request Form will be
gt; done.
gt; gt; I'll send a copy to you for Xmas! LOL
gt;
gt; Don't understand about nested invalid entries.
gt;
gt;
gt;