Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Query -- Data Type Mismatch StephenP Excel Discussion (Misc queries) 0 April 14th 05 07:05 PM
Type mismatch on LastRow daniel chen Excel Discussion (Misc queries) 8 April 11th 05 02:29 AM
changing the order shown in the save type menu Michelle Setting up and Configuration of Excel 1 March 18th 05 07:15 AM
Why type mismatch - R/T error 13 Jim May Excel Discussion (Misc queries) 5 January 9th 05 06:45 PM


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"