View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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