Collins, Darryl
Darryl.Collins at anz.com
Mon Apr 5 18:53:08 CDT 2010
Hi Folks, Slightly OT, but maybe of interest to a few of you, especially John C. A while back I mentioned that Active X controls in Excel or Excel Forms can be buggy and troublesome, even though they are easier work with via the VBE. For this reason Active X controls are not always the best option in Excel. Damon Longworth from the Excel list posted these links today regarding an issue another lister had. They will probably be useful for you to have a quick read is you are still working with Excel forms. '----- start of copied email -------------- Here is an overview with a general list of Forms and ActiveX controls. http://office.microsoft.com/en-us/excel/HA102376631033.aspx Here is some discussion of both, including references to the "buggy" behavior. <<http://www.dailydoseofexcel.com/archives/2004/08/11/controls-activex-v s-forms/>> <<http://peltiertech.com/WordPress/forms-controls-and-activex-controls-i n-excel/>> ' ---------- end of copied email --------------- Regards Darryl Collins | Data Integration Specialist Technology Institutional Program Management Office (TIPMO) ANZ, Level 23, 55 Collins Street, Melbourne Ph: +61 3 9658 1587 (Local: 03 9658 1587) Mobile: +61 418 381 548 (Local: 0418 381 548) Email: darryl.collins at anz.com <mailto:collinsd at anz.com> "This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential, may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."