If Then Macro

**Armored Wing** · 12-15-2011, 01:15 PM

Special thanks to tigeravatar on helping me with my last Macro. After my initial post, I figured out the what was wrong with my last macro.

With regards to this current project, I am trying write a simple if else statement that is trying to state that if cell "I19" is selected the message "enter number of property address" is display and If cell "I15" is selected then the message "enter total commitment amount" pops up. I am just not remembering what statement I need to make it work. Currently I know that this macro applies to every other cell.

Please Login or Register  to view this content.

**Steffen Thomsen** · 12-15-2011, 02:23 PM

Hi,

try this

Please Login or Register  to view this content.

**Armored Wing** · 12-15-2011, 02:40 PM

Thank you for your help Steffen, I actually discovered my own error just now. I saw that my intersecting ranges was hitting other cells and not the one I specify so I just modify it to "If not intersect" and it worked. I did past your code in excel and it also worked. Once again thank very much for helping me out. Mods can lock this thread now.