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

  • 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()


    End Sub

    Thank you!

    Wednesday, September 18, 2013 1:16 PM

All replies

  • 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)

    • Edited by James Cone Tuesday, October 25, 2016 1:26 AM
    Wednesday, September 18, 2013 2:07 PM
  • 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.
    Wednesday, September 18, 2013 2:40 PM
  • I figured it out!
    Wednesday, September 18, 2013 3:07 PM
  • RE:  "I figured it out!"
    Good to hear, but what was the problem?
    Jim Cone
    Wednesday, September 18, 2013 3:11 PM