Bad Syntax for calling public variables

I'm incredibly close to getting a couple of different things to work together well, but I'm doing something wrong that is probably pretty simple.

I have a macrobook that has two buttons which call macros. The first to select a workbook, and the second to select a macro. The workbook shows to the user in the following way:

DW1.png

The workbook they select ends up as a text string in B6, while the macro they wish to run on that book ends up in B9.

I am now trying to put a third macro together that runs the selected macro on the selected workbook, using the following code:

Outside of the function I have:

Please Login or Register  to view this content.

and the third button links to this:

Please Login or Register  to view this content.

This doesn't work at all. I understand HOW it's supposed to work, but I don't know how to code it correctly. My ultimate goal is to have this sub activate the selected Workbook, then execute the selected macro.

Ideas?

I was originally using StepOne and StepTwo across multiple functions - which is why I needed to use public variables.

What you guys have suggested so far works for StepOne:

Please Login or Register  to view this content.

However, StepTwo - which calls the macro, still does not work. I get an "Invalid Use of Property" error.

I guess my syntax on this is still bad - I use the Call feature in other parts in my book, and the word after "Call" is always the name of the function it's calling. However, in this instance, I'm asking it to call a variable name - so, not sure how to get that to work.

Hi Holger,

I'm not sure how to do that.

I got the correct VALUE in there by doing:

Please Login or Register  to view this content.

and if I use a MsgBox, the value is correct - I just don't know how to CALL it now as a function. I just have it in a string...

Okay - it works with

Please Login or Register  to view this content.

Thanks everyone!

Correct me if I'm wrong, but it looks like you're trying to "Call" a range? I don't believe you can Call a range. Try something like this? (untested)

Please Login or Register  to view this content.

You may need to reference your workbook name

Please Login or Register  to view this content.

Again, untested and may need tweaking to get the syntax perfect, but the principle behind it is sound