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...
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...