Thank you for your answer. It is quite close to what I want. In your example, instead of hard-code "32" and "200", I want it to be calculated automatically by using the table. Example: Max Age is ... from person name .... I want "..." conducted by codes because I am making a macro and the user will input detail. I think macro variable would help, however these macro variables are created in file while I need them as global ones in order to put it in to summary text box.
... View more