Storing VB Code in a variable withing a Macro

You will need to use VBComponet. Be sure to add the reference as I have commented.

Please Login or Register  to view this content.

Thanks, this seems to work alright during my testing. Is it possible though to make it create the code in the same module as the calling code? (i.e. I have my code that calls this code in a FORM, so is it possible to create the new Sub in the current module or Form that it's being called from?

Any help would be greatly appreciated.

I got the code to create in my form/module, I changed you line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

But now I get an error stating that it can't find the macro.

The macro is being built at the top of the Form just to note.

Any ideas how I can get around this?

Thanks again for all the help.

Userform code is Private which may be the cause.

A sample xls might help us help you.

ok, this only happens when the code is built in the form code. For some reason it can't find the macro that was created in the form code. Any reason why this won't work in the form code, looks like it works great in a module but I can't access the form variables and such from out side the form it seems.

If I can call the code that was provided in this thread from within the form, why wouldn't I be able to call the macro that is within the form as well?

I'll see if I can create an xls of what I'm trying to do, it may take some time though.

Thanks again for all your help.

You can access the Userform objects in Modules. The userform has to be open of course.

e.g.

Please Login or Register  to view this content.

Thank you so much, I built the new macro in a seperate module and adjusted my code a little,appending the form name to the variables being used and this solved the issue.

Thanks again!