06-03-2009, 12:03 AM
|
|
Valued Forum Contributor
|
|
Join Date: 21 Feb 2009
Location: mineral city, ohio
MS Office Version:Excel 2007; Excel 2000
Posts: 757
|
|
|
Re: Macro Bombs Excel 2000
I don't know where we are on this. I know that you told me
Quote:
|
the combo box remains visible after clicking on another cell.
|
and i asked you to
Quote:
|
make an entry in column F then TAB out of it to column G.
|
.
The ComboBox will indeed remain visible it you click out of it. It doesn't trigger the macro. Only a TAB or ENTER key will trigger the macro.
Have you tried the TAB key after entering data in column F? If so, what happens. Does Excel 2000 crash? Does the ComboBox disappear?
When you have time, please give me some feedback.
Thanks, John
|