Excel Crashes when testing userform

[Magnet]

Hi All,

To be able to controll data entered into a spreadsheet I have created a userform to manage this. Problem is it crashes excel when I am testing it. At the beginning it was only crashing when I was hitting the next button in the form. Now it seems to crash regardless of which button I am hiiting. Anyway. Can't find the source of the problem. My experience with vba is limited and the functions in the form is a mishmash of ammended codes found on different forums. I therefore suspect that the programming could be made easier and might be a bit too heavy for excel (?). I have attached the file below. Would really appreciate if somebody could at least test the userform on their computer and see if it crashes there also. If it is possible to find something that solves my issue I would be very thankful.

Ps 270412.xlsmPs 270412.xlsm

Magnet

[royUK]

No problems here using your form. I wouldn't use all those functions though, there's much more efficient ways to populate the textboxes

Please Login or Register  to view this content.

[Magnet]

Thanks Rob,

I changed the command according to your advice. Still seem to be a problem. To me it looks like the crash is coming more and more frequent. Meaning at the beginning it just happened occasionally. I also have had problems with a run-time error (run-time error '-2147417848(80010108)': Mehtod Value of object 'Range' failed). Once or twice the debugger managed to run before excel crashed. It then led me to the 'next' command and yellowing out the 'ActiveCell.Value = FrmEdit.cboTypeofAcquisition' Tried to do both with and without the userform reference. And the error happened on both.

Did you try to fill in more than five items? As mentioned the crash seem to happen after a while.

Magnet