[AccessD] Excel Forms and Active X issues (for John mostly)

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."



More information about the AccessD mailing list