Originally Posted by gmayor

It is impossible to guess what you have done wrong as all the macros required are present in the listing.

See example attached. Change the value in the text box to 'test' or 'actual' and click elsewhere in the document to run the macro.