Using Combobox as parameter

Hi everyone,

I have a function which has to contain the name of a combo and use it with some given parameters, here's my example:

Please Login or Register  to view this content.

I tried this several times but it gives me an error, could you please help me on this one?

Thank you in advance.

I get Compile Error: Method or Data Member Not Found just before the first line of the Sub.

Please Login or Register  to view this content.

I call the combo like this:

Please Login or Register  to view this content.

but when I highlight the combo parameter, it gives me:

cmblist= ""

Hope this helps.

Ok, here's my example on the Routines2 sheet, just click on the Show Form button and it will show you how I want to do this. And thanks a lot for your help.

Of course. Actually I have figured this out, the problem was that I was calling part of the combo instead of the whole thing, for example:

I tried to make it work like this

Please Login or Register  to view this content.

and the correct way to do it is this

Please Login or Register  to view this content.

then on the actual function I had this

Please Login or Register  to view this content.

and I tried this, and it worked!

Please Login or Register  to view this content.

Now I'm fine with this, nevertheless I appreciate your help. I'm attaching the file (2003 version of course). I didn't realize this was so simple, I'm new at making macros but very open to learn new things on the way.

Again, Thank you for your support.

I agree with you, it can cause some confusion and yes, it is overused. So what you're suggesting is to call an object with it's exact "location"?, like:

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Or what would be a shorter, yet efficient way to call the object?

Thanks in advance.