|
Combobox on change event
Why would adding Change events for comboboxes cause my workbook to crash
excel upon opening (when enable macros is selected (disabling macros doesn't cause it to crash))? Thanks Matt |
Combobox on change event
I think you need to be more specific Matt. What sort of comboboxes, how is
the event added, etc. More info the better. -- HTH RP (remove nothere from the email address if mailing direct) "Matt Jensen" wrote in message ... Why would adding Change events for comboboxes cause my workbook to crash excel upon opening (when enable macros is selected (disabling macros doesn't cause it to crash))? Thanks Matt |
Combobox on change event
Mmm, however, that seems to be the essential problem...
The 2 combo boxes, which are similar but distincly separate, are tied to defined name ranges. Their values are linked to cells in a different worksheet. I also need the values to be put in another 2 cells when the combobox changes (this will be used to track changes since file open). Adding the change events to my workbook, in the relevant worksheet code, causes the workbook to crash on open. There doesn't seem to be any duplicate referencing of the events or anything, or anything else related to these comboboxes. They are only 1 column comboboxes It must be some naming conflict I think... Matt "Bob Phillips" wrote in message ... I think you need to be more specific Matt. What sort of comboboxes, how is the event added, etc. More info the better. -- HTH RP (remove nothere from the email address if mailing direct) "Matt Jensen" wrote in message ... Why would adding Change events for comboboxes cause my workbook to crash excel upon opening (when enable macros is selected (disabling macros doesn't cause it to crash))? Thanks Matt |
Combobox on change event
Can you send me the workbook to look at?
What Excel version are you, OS? -- HTH RP (remove nothere from the email address if mailing direct) "Matt Jensen" wrote in message ... Mmm, however, that seems to be the essential problem... The 2 combo boxes, which are similar but distincly separate, are tied to defined name ranges. Their values are linked to cells in a different worksheet. I also need the values to be put in another 2 cells when the combobox changes (this will be used to track changes since file open). Adding the change events to my workbook, in the relevant worksheet code, causes the workbook to crash on open. There doesn't seem to be any duplicate referencing of the events or anything, or anything else related to these comboboxes. They are only 1 column comboboxes It must be some naming conflict I think... Matt "Bob Phillips" wrote in message ... I think you need to be more specific Matt. What sort of comboboxes, how is the event added, etc. More info the better. -- HTH RP (remove nothere from the email address if mailing direct) "Matt Jensen" wrote in message ... Why would adding Change events for comboboxes cause my workbook to crash excel upon opening (when enable macros is selected (disabling macros doesn't cause it to crash))? Thanks Matt |
Combobox on change event
Excel 2002, Win XP Pro SP2
Also acts strange on Excel 97, Windows NT Matt "Bob Phillips" wrote in message ... Can you send me the workbook to look at? What Excel version are you, OS? -- HTH RP (remove nothere from the email address if mailing direct) "Matt Jensen" wrote in message ... Mmm, however, that seems to be the essential problem... The 2 combo boxes, which are similar but distincly separate, are tied to defined name ranges. Their values are linked to cells in a different worksheet. I also need the values to be put in another 2 cells when the combobox changes (this will be used to track changes since file open). Adding the change events to my workbook, in the relevant worksheet code, causes the workbook to crash on open. There doesn't seem to be any duplicate referencing of the events or anything, or anything else related to these comboboxes. They are only 1 column comboboxes It must be some naming conflict I think... Matt "Bob Phillips" wrote in message ... I think you need to be more specific Matt. What sort of comboboxes, how is the event added, etc. More info the better. -- HTH RP (remove nothere from the email address if mailing direct) "Matt Jensen" wrote in message ... Why would adding Change events for comboboxes cause my workbook to crash excel upon opening (when enable macros is selected (disabling macros doesn't cause it to crash))? Thanks Matt |
| All times are GMT +1. The time now is 07:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com