Run macro upon value entered in B1 only if B1 > value in A1?

[Engineeronamission]

I've been using this Visual Basic code to run a macro when a value is entered into cell B1:

Please Login or Register  to view this content.

How would I change it so that the macro only runs when the value in cell B1 is greater than the value cell A1?

Thank you!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Engineeronamission]

Works! Thank you

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please mark your thread as Solved: Either Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.

[Engineeronamission]

Using the code suggested above, it works fine except when I delete the value out of the cell - it throws up the Run-time error '13' Type Mismatch. Do you know why?

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

I think it is reading "" as text.