VBA Forms and Illegal Operations Galore
I'm building a VBA form to retrieve data from an Excel
data source and there seem to be a few controls on the form that continuously cause illegal operations. I have traced the error to a few certain controls only, and it seems to occur when you try to reference them by name only (ie: typing ?txtControlName in the immediate pane causes a crash). this is not the case for other controls on the form and the problem is not limited to text boxes as some of my combos are affected too. This is a major pain as I have a number of procedures that are receiving control names as arguments in Parameter arrays, so has anyone any idea what is going on here? Thanks Andy |
All times are GMT +1. The time now is 03:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com