LinkBack URL
About LinkBacks
how would i get this module to do nothing if certain text is entered in the box
Please Login or Register to view this content.
how would i get this module to do nothing if certain text is entered in the boxPlease Login or Register to view this content.
Last edited by VBA Noob; 05-23-2007 at 01:29 PM.
why wouldnt you use an if statement?
Please Login or Register to view this content.
im not real familiar with this code? can you tell me what what "set value" or would be?
set value would be the text you are wanting it to avoid.. If i wanted to avoid all start times that were 10:00 then i would put
Please Login or Register to view this content.
ok, i thought so...so as of now. i have
thats still outputting an errorPlease Login or Register to view this content.
Last edited by VBA Noob; 05-23-2007 at 01:29 PM.
you are setting it equal to 0, but then you are not doing anything as the rest of your process is part of the else.. try this.
Please use code tags as it is the forum rules.
Please Login or Register to view this content.
thats still outputting a #NAME error
please post your entire code.
also i need a data examples.
(i can't zip files. so ill do the best i can by typing it out)Please Login or Register to view this content.
Name.......IN......OUT
ABC........HOL....... ...
DEF.......10:00....6:00
GHI.........VAC....... ....
JKL.........FMLA..... .....
MNO......12:00....10:00
i need the rest of the code where u are calling the function
C is the IN time and D is the OUT timePlease Login or Register to view this content.
do i have to do anything else besides save the module to take affect in the spreadsheet?
Neight, yesterday i asked you to change the title of this thread or risk having it locked or deleted, as you have not done this it has been locked!
Not all forums are the same - seek and you shall find
Apology given and accepted - Thread Unlocked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks