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.
Click to expand...
 
Top