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
|