another embedded excel question

M

mike

Is there an event that will be triggered when text is changed in a cell in an
embedded Excel object? Since worksheet events aren't put in a regular module,
I'm stuck as to how I might do this...
I'm wanting to turn the background color of any cell that has been edited to
yellow.
Thanks.
 
J

JuneTheSecond

If you double-click the Excel object embeded in your drawing, then Excel can
recieve hanndling cells, and the menus and toolbars on the window changes to
one of Excels. If you press the button for opening the VBA editor, the VBA
editor for emdeded Excel opens. You can make VBA program here for embeded
Excels, Various events might be found there.
 
M

mike

Thanks! I'll give that a try.

JuneTheSecond said:
If you double-click the Excel object embeded in your drawing, then Excel can
recieve hanndling cells, and the menus and toolbars on the window changes to
one of Excels. If you press the button for opening the VBA editor, the VBA
editor for emdeded Excel opens. You can make VBA program here for embeded
Excels, Various events might be found there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top