View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Excel 2007 formula calculation

Assuming a "slidebar" is a scroll bar I don't see any change in behavior
between Excel 2003 and 2007. When a scroll bar from either the Forms or
Control Toolbar toolbars is used (you didn't say which you were using) and a
linked cell changes value, the sheet_change event is not fired. I assume
you're using the sheet change event. But the scroll bar change event is
fired for a Control Toolbox scroll bar. And a macro attached to a Forms
toolbar scroll bar would also fire and it could calc the sheet.

--
Jim
"joeeng" wrote in message
...
| have ported great deal of vba code from Excel 2003 to Excel 2007. I am
| happy to say that most things worked, even things I thought would not.
| However, one issue has stumped me. I have some worksheets that have
| slidebars to change some values which in turn feed into the lookup_value
and
| reference for Hlookup, Vlookup, and Offset functions, respectively.
However,
| with autocalculation set to manual, Vlookup, Hlookup, and Offset functions
| are not recalculating when a me.calculate is issued via vba code in the
| worksheet module. This code works perfectly in Excel 2003. Does anyone
know
| why these worksheet functions are not updating and what can be done to
make
| them work in Excel 2007?