View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default error excel if embedded in word documents

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.