The question is moot, because Application.EnableEvents only pertains to
events associated with Excel objects and their events - Workbook, Worksheet,
Application. Events for the MSForms 2.0 controls are not affected by this
setting. I have never seen the behavior you describe. I think you would
have to examine what would cause a change in the combobox that would cause
the event to fire. Are there some formulas being recalculated that change
the rowsource of the comobobox. If so, you may need to populate the
combobox with code and remove the rowsource.

Regards,
Tom Ogilvy


"Bart" wrote in message
...
Hi Patrick,
I have the feeling that once a message is answered, no
other user tends to look at the question. So please be
careful when answering question and read the text
completely.
When your answer is of no use to me I then have no other
way to attract someone elses attention than by repsoting
my problem.

As I stated, the copying of the sheet is manually (the
user of my sheet just copies the sheet in the way I
discribed). So where would I put
the 'Application.EnableEvents' = False code if (as I said)
I have no knowledge of a worksheet_copy event.

Thanks

PS: could you reply to this message? Because I even have
the feeling that even authors of the thread don't worry
about following up.

-----Original Message-----
set
Application.EnableEvents = False
befor eyou do the copying
then reset to True when you want your events to work again

Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
Hello,
when i copy an excel97 worksheet (with ActiveX
comboboxes
on them) manually (rightmouseclick + ctrl +
drag&relaese)
the code for the combobox click event is called.
I'd like to prevent that from happening.

1. The combobox_change event is also called.
2. I found no Worksheet_copy event where I could
intercept
the combobox event (or it's just not documented?)

Thanks
.

.

Hi Tom,
I hope you follow your threads :-).
Here it comes.
Place an ActiveX combobox on a sheet.
Rightclick. Select properties.
Adjust:
Style: 2fmstyledropdownlist
Listfillrange: fill in a range (A1:A5)
Go out of design mode.
Put some values in A1:A5 and select a value with the
combobox.
Copy the sheet manually (leftclickmouse + ctrl)
The change or click event of the combobox is triggered.
(It's even trigered by just saving the file).

Do you know of a way around this?

I can tell you of other bugs with comboboxes too.

Bart

-----Original Message-----
The question is moot, because Application.EnableEvents
only pertains to
events associated with Excel objects and their events -
Workbook, Worksheet,
Application. Events for the MSForms 2.0 controls are
not affected by this
setting. I have never seen the behavior you describe. I
think you would
have to examine what would cause a change in the combobox
that would cause
the event to fire. Are there some formulas being
recalculated that change
the rowsource of the comobobox. If so, you may need to
populate the
combobox with code and remove the rowsource.

Regards,
Tom Ogilvy


"Bart" wrote in message
...
Hi Patrick,
I have the feeling that once a message is answered, no
other user tends to look at the question. So please be
careful when answering question and read the text
completely.
When your answer is of no use to me I then have no other
way to attract someone elses attention than by repsoting
my problem.

As I stated, the copying of the sheet is manually (the
user of my sheet just copies the sheet in the way I
discribed). So where would I put
the 'Application.EnableEvents' = False code if (as I
said)
I have no knowledge of a worksheet_copy event.

Thanks

PS: could you reply to this message? Because I even have
the feeling that even authors of the thread don't worry
about following up.

-----Original Message-----
set
Application.EnableEvents = False
befor eyou do the copying
then reset to True when you want your events to work
again

Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
Hello,
when i copy an excel97 worksheet (with ActiveX
comboboxes
on them) manually (rightmouseclick + ctrl +
drag&relaese)
the code for the combobox click event is called.
I'd like to prevent that from happening.

1. The combobox_change event is also called.
2. I found no Worksheet_copy event where I could
intercept
the combobox event (or it's just not documented?)

Thanks
.

.



.

Did someone find the answer to this problem.

Because my ComboBox_Change event fires so often, even if I hav
EnableEvents set to false, so I don't know what to do.

I posted my message about problem with EnableEvents several times i
this forum, but hadn't gotten any solutions so far.

it fires up even when I switch from Application.Calculation = xlManua
to Application.calculation = xlAutomatic

--
Intellihom
-----------------------------------------------------------------------
Intellihome's Profile: http://www.msusenet.com/member.php?userid=147
View this thread: http://www.msusenet.com/t-47687