VBA Form Name Object Variable

[mrlemmer11]

Hi All,

First post here.

I've spent 3 hours trying to figure this out and just can't do it.

Basically I have a UserForm in WORD VBA with the Excel Reference added onto it. I have named my UserForm under properties (Name) to formStage1.

Now I have a whole bunch of command buttons and which saves the data from their related text fields to different variables.... this all works. However, I'm trying to be mindful to the fact that I may want to change my (Name) from formStage1 to formStage37 one day.... and if I do that, I would need to go into my code and change all of my strEdition = formStage1.boxEdition to strEdition = formStage37.boxEdition ..... which would be a big pain

I've tried so many ways to declare oForm1 publicly outside of any Subs and then set it using set oForm1 = UserForms.Add(formStage1) and about 100 different things.... and I can't get it to work.

Any Help? Thanks everyone!

 

[Kyle123]

Something like:

Dim oForm As formStage1
'...
Set oForm = formStage1

Is there a particular reason you chose not to put the code in the userform? It then doesn't matter what its name is

 

[mrlemmer11]

Something like:

Is there a particular reason you chose not to put the code in the userform? It then doesn't matter what its name is

Could you explain this a little bit more?

-----

Kyle123,

Thanks you so much. It worked. I understand general programming theory, how functions, arrays, etc work. I can review code and made it work for me after trial and error.... it's much longer than a proficient programmer, but it eventually gets done.

I do run into problems when referencing objects and how they work exactly. I should prob spend some time researching that and get a better understanding.