MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Declaring MenuObject As CommandBarPopup

  Asked By: Harley    Date: Sep 13    Category: MS Office    Views: 1441

Could anyone help me understand why I can't declare;
Dim MenuObject As CommandBarPopup.
Error Message is:
Compile error: User-defined type not defined



1 Answer Found

Answer #1    Answered By: Cay Nguyen     Answered On: Sep 13

If I try to Dim MenuObject As CommandBarPopup in my Personal.xls's Module, it'll
give me "Compile Error: User-defined type  not defined".

Personal.xls is stored in XLSTART.

However, if I Dim MenuObject As CommandBarPopup in a new Workbook, it'll work.

Would anyone help  me understand  why is this happening?

Didn't find what you were looking for? Find more on Declaring MenuObject As CommandBarPopup Or get search suggestion and latest updates.