I am getting a " compile error method or data member not found vba excel " when I try to show a form.
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()
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).
Portland, Oregon USA
Extras for Excel add-in (classic menu, TOC, sheet sorting & ...)