I am getting a " compile error method or data member not found vba excel " when I try to show a form.
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 & ...)