[Q] Save As throws type mismatch error in control's code?
 

Hi,

Here's a new one... When I try to save my file under a different filename,
it throws a type mismatch error in the change event code for a combo box on
one of my sheets. I can save the file just fine without having it throw the
error. The weirdest part of it all is that I didn't do anything with the
part of the workbook that uses that control.

I suspect that something is corrupted, but I have no idea what that
ultimately means or how to correct it.

Any ideas? Please?

....Jay

Do you have a linked cell for that combobox?
Do you have listfillrange for that combobox?

If you remove those from the combobox, does everything work ok?

If you put them on a different worksheet, does everything work ok?

If it only works if you remove the linkedcell and listfillrange, maybe you can
populate the list via code and populate the cell via code, too.



Jason Weiss wrote:

Hi,

Here's a new one... When I try to save my file under a different filename,
it throws a type mismatch error in the change event code for a combo box on
one of my sheets. I can save the file just fine without having it throw the
error. The weirdest part of it all is that I didn't do anything with the
part of the workbook that uses that control.

I suspect that something is corrupted, but I have no idea what that
ultimately means or how to correct it.

Any ideas? Please?

...Jay

--

Dave Peterson