Runtime Error 1004 in dynamic UserForm

[vijayendra.shukla]

Hi all,

I am using a code available on one of the sites for creating a dynamic user form. but i am not able to proceed at all because of Runtime Error 1004 "Application Defined or Object Defined error".

here is the part where i am getting it:

Sub MakeUserForm()
    Dim TempForm As Object
    Dim NewLabel As MSForms.Label
    Dim NewComboBox As MSForms.ComboBox
    Dim NewButton As MSForms.commandbutton
    Dim NewCheckBox As MSForms.CheckBox
    Dim X As Integer
    Dim iNoOfSheets As Integer
    Dim iTotalRows As Integer
 
    'This is to stop screen flashing while creating form
 
    Application.VBE.MainWindow.Visible = False
 
   Set TempForm = ThisWorkbook.VBProject.VBComponents.Add(3)

FYI - I have included the necessary libraries eg. MS Form,Object lib, VBA.

Thanks in advance for your time and help.

 

[Mike Blackman]

Hi,

Do you have "Trust Access to Visual Basic" checked in your Macro Security - Trusted Publishers section?

 

[vijayendra.shukla]

Hi Mike,

Just now i checked the Trusted Publishers section, but it is not showing me anything? the whole table is blank. What to do?

 

[vijayendra.shukla]

Hi,

Do you have "Trust Access to Visual Basic" checked in your Macro Security - Trusted Publishers section?

Hey Mike, just now i checked the box under Macro Settings -> Developer Macro Settings -> "Trust access to the VBA project object model" and you know what i did not get any error this time. What i have done right now, is correct? Was this the problem?

 

[Mike Blackman]

Hi,

Sorry so used to 2003, I'm assuming your on 2007 or 2010. Yeah, you need to check the Trust Access to VB button to be able to alter/add components to projects, import modules etc.

 

[vijayendra.shukla]

Sorry i did not tell you about my Excel version. Yeah it is 2007.

Anyway Thanks a lot Mike.