Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Spurious ComboBox change event

a calculate can cause this if your control is bound to the sheet with
linkedcell or possibly listfillrange.

If you remove these links, the problem should go away.

If that solves the problem, then you can use the Click event to write the
selected value to the cell and in the case of the listfillrange, populate
the combobox with code as well.

--
Regards,
Tom Ogilvy

"Tony Adams" wrote in message
...
I have a combobox on one sheet with a VBA routine hadling
the change event. My problem is that thsi event is being
triggered when doing things (other VBA code) on another
worksheet.

Any ideas ????

Thanks



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
Change minimumscale with the change event of a combobox Herbert Chan Excel Programming 1 April 11th 04 12:43 PM
combobox change event scrabtree23[_2_] Excel Programming 3 October 20th 03 05:56 PM
Generic ComboBox change event steve Excel Programming 7 October 14th 03 07:30 PM
Combobox Change Event when file is saved as E.Anderegg Excel Programming 1 October 1st 03 05:03 PM
Excel 2000 ComboBox Code Change event Matt. Excel Programming 3 July 28th 03 03:29 PM


All times are GMT +1. The time now is 03:45 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"