Seriously VBA, what the hell? (Calling Userforms)

[bonzodog1990]

Hi All,

This is making me tear my hair out, please tell me what I'm missing!

I have this, very simple, code:

Private Sub BondButton_Click()
Rows("2:2").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
SelectTradeType.Hide
EnterABond01.Show

End Sub
Private Sub IRSButton_Click()
Rows("2:2").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

SelectTradeType.Hide
EnterAnIrs.Show

Two buttons on userform that call other userforms, no problems, except the bottom one works to call 'EnterAnIrs' and the top one 'EnterABond01' just doesn't. I've tried all kinds of names for the 'EnterABond01' userform, and nothing works. I just get the error msg:

'Object doesn't support this property or method'

Can you please give me a list of things to check/reasons this might be happening?

Many thanks,

Ben

 

[DragonWood]

Re: Seriously VBA, what the @#!*% ? (Calling Userforms)

It sounds to me like your "EnterAnIrs" and "EnterABond01" are both forms that the code wants to display when run.

If the one is working, and the other isn't, than the "bond" form is either named something different or doesn't exist.

Look in your code editor under the Forms section and make sure the Bond form is there and named correctly.

 

[RoryA]

Re: Seriously VBA, what the @#!*% ? (Calling Userforms)

Can you run that form from anywhere? I'd start by checking the Initialize or Activate event code of the form.

 

[bonzodog1990]

The form is definitely there, definitely named correctly, as in i copied and pasted the name rather than re-typing it.

the line to show the userform generates the error message no matter where you put it.

 

[bonzodog1990]

And the really weird thing, VBA autofills the name as I start typing, as in if I type the first few letters of the name it autocompletes the rest, and THEN tells me it isn't an object! No fair.

 

[RoryA]

Re: Seriously VBA, what the @#!*% ? (Calling Userforms)

I'd start by checking the Initialize or Activate event code of the form.

 

[bonzodog1990]

What am I looking for there? The initialize section of code on the form I'm trying to call just has some code to get suggested values into some comboboxes, no declarations about the form or anything that might screw things up.

There's nothing in the 'initialize' section for the code above.

 

[bonzodog1990]

Ah, you are right however that the problem is with the initialize code. trying to break through it and work out what it doesn't like...

 

[RoryA]

If you post it, we may be able to help. Alternatively, run the form, when the error occurs, press f8 repeatedly to step through the code until you hit the real error line.

 

[bonzodog1990]

Found the problem. I'd forgotten to change the name on one of the comboboxes.

Very irritating, and thanks for the very obvious and sensible suggestion which I probably never would have thought to do