I have a file excel with some code VBA to manage some population. It works
right stand-alone, but if I embed the excel file in a word documents it goes
in error (error that stop excel itself). Because the code is fired by a
combobox change, if I write a random cell for example before fire the code
the error doesn't appear, but if the first action on the file is changing the
combobox I get the error (seems that need somthing like a "set context").
I use office 2000 pro. Thanks in advance for your help.

The workaround used for the moment is to valorize the "linkedCell" attribute
of the combobox choosing a cell behind the combo itself and reference this
cell in the code when i need the combobox value ... I don't know why but in
this seems all ok.
Bye.

"MZ" wrote:

I have a file excel with some code VBA to manage some population. It works
right stand-alone, but if I embed the excel file in a word documents it goes
in error (error that stop excel itself). Because the code is fired by a
combobox change, if I write a random cell for example before fire the code
the error doesn't appear, but if the first action on the file is changing the
combobox I get the error (seems that need somthing like a "set context").
I use office 2000 pro. Thanks in advance for your help.

In the click event you also might try

application.Activecell.Activate
as the first line.

--
Regards.
Tom Ogilvy

"MZ" wrote in message
...
The workaround used for the moment is to valorize the "linkedCell"
attribute
of the combobox choosing a cell behind the combo itself and reference this
cell in the code when i need the combobox value ... I don't know why but
in
this seems all ok.
Bye.

"MZ" wrote:

I have a file excel with some code VBA to manage some population. It
works
right stand-alone, but if I embed the excel file in a word documents it
goes
in error (error that stop excel itself). Because the code is fired by a
combobox change, if I write a random cell for example before fire the
code
the error doesn't appear, but if the first action on the file is
changing the
combobox I get the error (seems that need somthing like a "set
context").
I use office 2000 pro. Thanks in advance for your help.