Loop on example on stata command

Dear Colleagues,

I often make use of loops in Stata. For instance, if I want to generate a set of similar tables for a number of variables I would type:

Please Login or Register  to view this content.

It's neat and very simple, put required variable names after the word varlist and introduce them into the loop with use of the `var' keyword.

I want to do analogous loop in VBA. I will use it to automatically generate a number of PDFs. I would like it to look like that:

Please Login or Register  to view this content.

What I missing is a loop component where I could substitute different text strings for the variable_name. I will appreciate any help on that.

I'm not sure it is exactly what you want but it should be a good starting point:

Please Login or Register  to view this content.

Hi yudlugar,

Thanks very much for your reply. It looks handy. I hope you don't mind that I am going to ask a wee question - where can I define a sets of text strings that will be substituted for the variable_name? Ideally, I would like to type somewhere in the macro. I have a list of 32 indicators that I will be substituting for the variable_name.

In the example I gave you the text strings would be stored in the range E5:J5. If you wanted to type them in the macro you could use an array like this:

Please Login or Register  to view this content.

Yudlugar,

again, thanks for your helpful reply. The range in my initial post corresponds to a drop down menu. The menu is available to end-users to "play with" but in the macro I'm using it to insert the indicator name. Number of tables update on change in that field.

Yudlugar,

again, thanks for your helpful reply. The range in my initial post corresponds to a drop down menu. The menu is available to end-users to "play with" but in the macro I'm using it to insert the indicator name. Number of tables update on change in that field.