I am getting a " compile error method or data member not found vba excel " when I try to show a form.

Question

I set up a command button to show a form upon on clicking. I have the right name of the form in the formula and it is still giving me the error... here is what I have:

Private Sub ChangeCommandButton1_Click()

SuggestionForm.Show

End Sub

Thank you!

Answer 1

Is the form in the same workbook as the CommandButton?

The Name of the form and The form Caption are different properties.
The form must be called using the Name (which may still be UserForm1).

'---
Jim Cone
Portland, Oregon USA
https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Answer 2

I  changed the name and the caption. They are both SuggestionForm, and it it is on the same workbook. I am getting error 424 when I click on the command button.

Answer 3

I figured it out!

Answer 4

RE:  "I figured it out!"
Good to hear, but what was the problem?
'---
Jim Cone