‘SCOTCH TAPE –vs- POST IT NOTE nested “If” macro, that has been running continually for me for years.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o> <o></o>
Code:
Sub PostItNoteVsScotchTape ()
<o:p></o:p>
If (you need to use a [FONT=Times New Roman]POST IT NOTE [/FONT]) Then<o:p></o:p>
If (environment is clean + no wind) Then<o:p></o:p>
Use POST IT NOTE only<o:p></o:p>
ElseIf (environment is clean + windy) Then<o:p></o:p>
Use POST IT NOTE + SCOTCH TAPE<o:p></o:p>
ElseIf(environment is dirty + windy) Then<o:p></o:p>
Use POST IT NOTE + SCOTCH TAPE + MORE SCOTCH TAPE<o:p></o:p>
ElseIf(environment is dirty + windy + BEANIE THE CAT is loose)
Do While BEANIE THE CAT is still loose<o:p></o:p>
Chase BEANIE THE CAT<o:p></o:p>
Loop<o:p></o:p>
Lock up BEANIE THE CAT in his room again<o:p></o:p>
Use POST IT NOTE + SCOTCH TAPE + MORE SCOTCH TAPE<o:p></o:p>
Else<o:p></o:p>
‘Do nothing because nothing else matters<o:p></o:p>
End If<o:p></o:p>
End If
<o:p></o:p>
End Sub
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.