Userform Function Call works in Module2 but not Module1

[hotabae]

Hello!

I have an option button collection which monitors changes. When a new option button is selected, I want to pass the .Caption of that button into a userform update.

Ultimately, the code in question ends up looking like this:

Sub Update(caption As String)
UserForm1.updateButton(caption)
End Sub

This sub is in Module2, and I have updateButton(caption As String) located within the UserForm1 code.


At this point it works just fine, but when I move the above code from Module2 to Module1, I start getting a compile error, and the "Auto List Members" functionality stops working.

It is almost like Excel can't find UserForm1 from within Module1.

Does anyone have any idea why this is happening?


Thanks!

 

[dmt32]

Hi,

your userform code

Sub updateButton(caption As String)


End Sub

have you named a control on the userform with the same name? if so, rename either the control or the Sub.
Also, have you declared your sub as Private? if so, change the Private declaration.

Dave

 

[hotabae]

have you named a control on the userform with the same name?

Dave

I do not have a control with the same name. That did get me thinking though, and I managed to figure it out.

Somehow I named my form using the same name as a pre-existing Sub that was in Module1.

UserForm1.updateButton

was trying to call

Sub UserForm1()

rather than using the Userform's Code

I have renamed the Sub, and it seems to be working just fine now.

Thanks!