Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
msg box to stop user if range is "" (tricky one)
hey...
fyi... at the moment i got 2 sheets that has a row (B23:T23) where the user needs to enter closing stock. (a couple of colums are blank(future use)Sheet2 O:T). in the workbook i got a couple modules. one of them Clear the cells that need to be cleard and then cary the closing stock over to the column for the next days opening(B5:T5). what i need is a code that i can put at the start of my existing code that will check if range b5 = something (product name/" ") then if b23 = "" msgbox "unable to clear". if range c5 = something (product name/" ") then if c23 = "" msgbox "unable to clear". if range d5 = somthing (product name/" ") then if d23 = "" msgbox "unabale to clear". etc in a nutshell the user should not be able to print and clear the workbook if a column got a product name(B5:T5) with a blank closing(B23:T23). (and told in a msg box all the products names with a blank closing) -- Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
msg box to stop user if range is "" (tricky one)
On Mar 25, 1:33*pm, pswanie wrote:
hey... fyi... at the moment i got 2 sheets that has a row (B23:T23) where the user needs to enter closing stock. *(a couple of colums are blank(future use)Sheet2 O:T). *in the workbook i got a couple modules. one of them Clear the cells that need to be cleard and then cary the closing stock over to the column for the next days opening(B5:T5). what i need is a code that i can put at the start of my existing code that will check if range b5 = something (product name/" ") then if b23 = "" msgbox "unable to clear". if range c5 = something (product name/" ") then if c23 = "" msgbox "unable to clear". if range d5 = somthing (product name/" ") then if d23 = "" msgbox "unabale to clear". etc in a nutshell the user should not be able *to print and clear the workbook if a column got a product name(B5:T5) with a blank closing(B23:T23). (and told in a msg box all the products names with a blank closing) -- Helpful advice on posting to newsgroups here...http://www.cpearson.com/excel/newposte.htm Try this: If Cells(5,2) < "" Then If Cells(23,2) = "" Then Call Msgbox "unable to clear" End If End If etc. HopeThatHelps Chris |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
msg box to stop user if range is "" (tricky one)
will i need to repeat this for every column? or is there a loop idea that i can do? where would i tell it to first do sheet1 and then sheet2 Try this: If Cells(5,2) < "" Then If Cells(23,2) = "" Then Call Msgbox "unable to clear" End If End If |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
msg box to stop user if range is "" (tricky one)
Loop the columns
For ColNum To 2 To 20 If Cells(5,ColNum) < "" Then If Cells(23,ColNum) = "" Then Call Msgbox "unable to clear" End If End If Next ColNum -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pswanie" wrote in message ... will i need to repeat this for every column? or is there a loop idea that i can do? where would i tell it to first do sheet1 and then sheet2 Try this: If Cells(5,2) < "" Then If Cells(23,2) = "" Then Call Msgbox "unable to clear" End If End If |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
msg box to stop user if range is "" (tricky one)
i get the
Call Msgbox "unable to clear" in red aswell... Also a typo. Use either this.... Call MsgBox("unable to clear") or this... MsgBox "unable to clear" Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop "global" hyperlinks changing to "local" links? | Excel Worksheet Functions | |||
"Tricky Situation" - Validation Formula | Excel Discussion (Misc queries) | |||
Stop users from accessing "Protection" option from "Tools" menu | Excel Programming | |||
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |