Code for a variable?

Wilker12 · Jun 29th 2020

Hello!

How to copy a class's VBA source code to a variable?

I don't know if there would be a command like this: Var1 = Sheets("Sheet1").VBACode

Thanks.

**AliGW** · Jun 30th 2020

If you made a mistake in your post, just add a new post to the thread.

**royUK** · Jun 30th 2020

Please explain more fully what you mean

Wilker12 · Jun 30th 2020

I found: Var1 = ThisWorkbook.VBProject.VBComponents().CodeModule.Lines()

**royUK** · Jun 30th 2020

I'm still not sure what you would use it for.

Participate now!