It will not work. The #Define directive has been discussed here several times. #Define is a compile directive. It replaces all occurences of the string "_DefineCaption" with the string "1" before compilation. This meens that your compiled text will be:
=MYCAPTION(1)
So, MyCaption will always return "String1". You can't use here a constant. You must use a variable or a form's property.