VBA Macro makes Excel crash... what are the causes to investigate?

[Malkavian]

Hi!

So I made this big business program that basicly import huge data tables from an Access database to Excel sheets. The user enter a group number in input and the datas of that specific group are shown on the userform. The program allows to add, remove and edit groups and those modifications are exported back to the Access database. The program is HUGE. I have hundreds of textboxes and thousands of lines of datas.

Everything worked fine but now, one button makes Excel crash... I can't figure what's the problem is since when I run the macro assigned to that button step by step (with F8), the macro runs just fine.

What should I investigate?? Never had this kind of issue with VBA before...

 

[Malkavian]

It wasn't working because it was refering to Userform1 most likely.

this should work just fine:

Dim c As Control
    For Each c In UserForm2.Controls
        If c.Name Like "TextBox" Then c.Text = ""
    Next c
UserForm2.Hide
UserForm1.Show

Nah I assure you that my code was correctly referring to Userform2. You probably saw the Userform1 reference in VoG's code.

 

[yytsunamiyy]

Weird. I just made up a Userform called Userform2, Placed a couple of Textboxes and a button there and the code:

Private Sub CommandButton1_Click()
Dim c As Control
    For Each c In UserForm2.Controls
        If c.Name Like "TextBox*" Then c.Text = ""
    Next c
End Sub

ran just fine. In my last post I forgot to include the * in If c.Name Like "TextBox*" Then c.Text = ""

Which line did it bug out at when you were testing it?

 

[Malkavian]

Weird to know that it worked for you!

See my previous post :

...
It never enters the procedure if... VBA doesn't seem to be recognizing the wildcard caracter (*) properly. However, if I replace "TextBox*" by "TextBox1" it goes in and works for that specific TextBox . So the issue has to be with the *.
...

It didn't "bug out", it just never even entered the If procedure...!