design mode error

[acapro]

Hi I have a box that continually pops up "can't exit design mode because control 'combobox38' can not be created" can some help me find combo box 38 so I can stop this error continuing to pop up

Thanks in advance

 

[MARK858]

Try running the first code below and if it finds the combobox then run the second code to delete it.

Sub FindCbox()
Dim obj As Object
    For Each obj In ActiveSheet.OLEObjects
        If TypeOf obj.Object Is MSForms.ComboBox Then
            MsgBox obj.Name
        End If
    Next
End Sub

Sub DelCbox()
Dim obj As Object
For Each obj In ActiveSheet.OLEObjects
    If TypeOf obj.Object Is MSForms.ComboBox Then
        If LCase(obj.Name) = "combobox38" Then
            obj.Delete
        End If
    End If
Next
End Sub

 

[acapro]

Try running the first code below and if it finds the combobox then run the second code to delete it.

Sub FindCbox()
Dim obj As Object
    For Each obj In ActiveSheet.OLEObjects
        If TypeOf obj.Object Is MSForms.ComboBox Then
            MsgBox obj.Name
        End If
    Next
End Sub

Sub DelCbox()
Dim obj As Object
For Each obj In ActiveSheet.OLEObjects
    If TypeOf obj.Object Is MSForms.ComboBox Then
        If LCase(obj.Name) = "combobox38" Then
            obj.Delete
        End If
    End If
Next
End Sub

Mark Mark,

I am a new to the world of excel where do I put the code

 

[MARK858]

You put the code in a regular module. Press ALT-F11 and paste the code in the white space that appears.
Click in front of the word Sub in the the first code then then click Run - Run Sub/UserForm.

 

[acapro]

You put the code in a regular module. Press ALT-F11 and paste the code in the white space that appears.
Click in front of the word Sub in the the first code then then click Run - Run Sub/UserForm.

Thanks Mark but it came up with a box saying " runtime error 57121. application defined or object defined error"

 

[MARK858]

Go back to the VBE editor click tools, references and see if any references are marked as missing and make sure that Micosoft forms 2.0 object library and OLE automation are checked (and your Excel and Office library as well while you are there).

And check that you have actually enabled ActiveX controls.

 

[acapro]

Go back to the VBE editor click tools, references and see if any references are marked as missing and make sure that Micosoft forms 2.0 object library and OLE automation are checked (and your Excel and Office library as well while you are there).

And check that you have actually enabled ActiveX controls.

What would it say if there was a reference missing?

other than that 2.0 and OLE were checked

I set up about 30 boxes yesterday without any problems

I will send you a private message

 

[MARK858]

What would it say if there was a reference missing?

Missing.

I am assuming that you are using ActiveX controls and not forms controls.
See my reply to your personal message about how to create a link to your file.