Hello all,
I have a UDF in a module which is the controlsource of multiple textboxes.
In addition to setting the value of the textbox, I'd like the UDF to set the fore and back colors rather than use conditional formatting (I'm attempting to speed up a very slow report).
However, I can't find a way to self-reference the textbox in order to set the fore and back colors.
It'll be great if somebody has a suggestion about the best way to do this!
I have a UDF in a module which is the controlsource of multiple textboxes.
In addition to setting the value of the textbox, I'd like the UDF to set the fore and back colors rather than use conditional formatting (I'm attempting to speed up a very slow report).
However, I can't find a way to self-reference the textbox in order to set the fore and back colors.
It'll be great if somebody has a suggestion about the best way to do this!