Is it possible to call a subprocedure within VBA (Excel 2007) using a variable or value from a cell in a worksheet? If so, please provide code to do so.
Here is the pseudocode of what I'm trying to accomplish:
Cell D3 value is "Y"
Cell E3 value is "TestMacro"
If Range("D3") = "Y" Then
MsgBox "Test Successful"