error excel if embedded in word documents

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" <[email protected]> wrote in message
news:[email protected]...
> 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.