I've developed some forms with code in Windows XP using Excel XP. The users for the file run Excel 97 on Windows 2000 Professional.

This is the first thing I've developed on XP but I certainly didn't use anything that I hadn't used when I had 97.

It runs fine on my machine and anyone else who uses XP, but it generates the following error on the 97 machines:

"excel.exe has generated errors and will be closed by Windows"

Excel then completely closes out.

Running the program step-by-step, I found it crashes at the following statements:
txtSomething.value = range("B3").value (textbox)
cmbSomething.additem(variable) (combobox)

The thing is, is that each of these is one of many similar statements in a list in the code but only 1 or 2 out of 10 will kill the program, and I cannot find any pattern.

Thanks in advance

Paul