T
trae
I am having this problem with this file I have been
working on. I am not sure if it is a reference problem
or what. When I start up excel, everything seems to be
fine. I created a button on a worksheet to start my
macro with brings up a userform and then I can do
different functions or whatnot from that point. But
sometimes when I click that button after I just opened up
the file, excel will crash and say Automation Error and
then shutdown and reopen. At other times, Excel will say
that there is a type mismatch, but when I go to debug,
excel crashes. However, if I hit end at that point, and
go to the reference box in VBE, I will switch the
positions of the OLE Automation and the Windows Common
Controls. Does anyone know what might be going on
Trae
working on. I am not sure if it is a reference problem
or what. When I start up excel, everything seems to be
fine. I created a button on a worksheet to start my
macro with brings up a userform and then I can do
different functions or whatnot from that point. But
sometimes when I click that button after I just opened up
the file, excel will crash and say Automation Error and
then shutdown and reopen. At other times, Excel will say
that there is a type mismatch, but when I go to debug,
excel crashes. However, if I hit end at that point, and
go to the reference box in VBE, I will switch the
positions of the OLE Automation and the Windows Common
Controls. Does anyone know what might be going on
Trae