Send Email when value less than help! :confused::confused:

Hi Guru's

Ok so i have found a vba thats perfect for my needs and works ...Sort of....

If a cell value is less than 3 it does send an email however my problem is i need it to send a email when M6 who's formula is ='Parts List'!L5 shows a value of less than 3 which for some reason this VBA refuses to do? infact it will only send an email if a standard cell shows a figure and not the result of a formula so what am i doing wrong?

I also cannot just reference cell L5 on the parts list tab either as that is a formula too =Stock!K6-'Parts List'!K5 ..... the formulas work fine and simply display the value in numeric form but as mentioned the below VBA just wont work when referencing a formula result?

PLEASE HELP!!!

HTML Code: 

.
This works here :

Please Login or Register  to view this content.

thanks for the reply , as before your code also work if the cell has a specific number entered but as m6 is the result of a formula then again nothing happens and no mail is opened.

This is driving me nuts

There must be a way to make this work

I placed a formula in M6 ... =A1

Then whenever I changed the Value in A1 it changed the value in M6 to match. So long as the value in A1 was less than 3, it worked here.

The email macro is located in a regular module.

Have a look at the attached file below, i have taken your spreadsheet and changed it to how i need it to give you a better idea of the problem.

See if this change is what you are seeking :

Now we are getting somewhere!!!!

Logit you are a genius!!

"Logit you are a genius!!"

I slept at a Holiday Inn Express last night. *smile*

Ok.... so new issue...

I want to add this for multiple rows m6 m7 m8 etc... the =IF(('Parts List'!L5)<3,'Parts List'!L5,"") argument gives me the desired results but the email box will only show for the original M6.

I adjusted the same argument moving down one cell each time so: =IF(('Parts List'!L6)<3,'Parts List'!L6,"") =IF(('Parts List'!L7)<3,'Parts List'!L7,"") etc...

I created the following as a test

HTML Code: 

HTML Code: 

now im sure i am doing something stupid but question is what?! and why is only m6 triggering the email?

ARGHHH This is driving me MAD!! nothing works after M6 when it comes to sending an email!!

Offered a solution as such below but i keep getting a 424 error?

Please Login or Register  to view this content.