Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
VBA Control Array of Me Won't Fire Class Functions
Name:
Trip Ives
Email (spam proof):
Email the originator of this post
Date:
Wednesday, October 05, 2005
Hits:
64
Discussion (Terms and Conditions):
Thank you so much of the VBA Control Array example/download which illustrates how to dynamically create an array of controls in a worksheet. (here: http://www.vbusers.com/downloads/download.asp#item13) I was wondering though, why does it only seem to work if you create an new workbook? I've tried to get it to work by creating a new worksheet and everything runs fine. It even goes through the Initialization() sub of the Class module. Yet, when you go to use the control the _chang event does not fire. I've been trying now for four hours. Any direction anyone could provide would be greatly appreciated. Thanks!! Trip Ives

Sponsored by the best FTP application on the internet: