ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent automatic combobox event trigger (https://www.excelbanter.com/excel-programming/355606-prevent-automatic-combobox-event-trigger.html)

[email protected]

Prevent automatic combobox event trigger
 
Hi,
i am facing problems with comboboxes in excel workbooks.
my workbook contains few sheets each of which contain one or two
comboboxes.
The event procedures for these comboboxes, fill certain cells based on
some calculation.
The listfillrange of these comboboxes are populated using named ranges.
The problem is that, whenever i add or delete certain rows in the named
range or do file-saveas
the event procedures of these combos are getting called.
Can someone explain what iam doing wrong here?

regards
thulasidhar



All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com