Macro Bombs Excel 2000

**Leith Ross** · 06-02-2009, 12:16 AM

Hello John,

You were right about the server problems. Everything should be back to normal according to forum's owner. I have been occupied about all day with other things and just back to look at the posts. If you could post the workbook, it would make it faster to troubleshoot the trouble the problem. I have Excel 2000 and can run it as is.

**jaslake** · 06-02-2009, 12:30 AM

I thought I had posted the workbook. In the event not, I am uploading it again.

Thanks Leith.

John

**Leith Ross** · 06-02-2009, 01:05 AM

Hello John,

This time there shouldn't be any server related snafus with the workbook. I rather be sure the only problems with the workbook are the original ones.

Thanks,
Leith Ross

**Leith Ross** · 06-02-2009, 01:22 AM

Hello John,

It runs using Excel 2000, but the combo box remains visible after clicking on another cell. I made several entries in column "I" and "J" and it didn't error.

**Leith Ross** · 06-02-2009, 01:34 AM

Hello John,

I get the same behaviour in Excel 2003. The text box remains visible, and Excel doesn't crash.

**jaslake** · 06-02-2009, 01:43 AM

Leith...make an entry in column F then TAB out of it to column G. This is where things go south on me.

Does your system duplicate that? If not, what are you running for an operating system? I've tried this on two different computers today, both running Windows 2000 and Excel 2000 with the same result (Excel shuts down).

Please look at the code for Check Register to make certain I've not commented out

cboTemp.Visible = False

. If I have, please remove the ' and try to rerun.

If you can't duplicate the problem, I'm not sure where to go next.

Thanks, John

**jaslake** · 06-02-2009, 01:50 AM

I don't understand. The ComboBox should disappear when you tab to the next column. That's what the code says. That particular line is the one that caused my system (and the other one I ran today) to crash.

You're not getting that?

John

**jaslake** · 06-02-2009, 02:14 AM

I tried this on my resident copy. If you CLICK out of the cell (column F), the ComboBox does stay visible. If you TAB out of it, it disappears.

What say you?

John