Not making Invisible
Status: Beta
Brought to you by:
johngunther
Example 1
Dim array1() as string, array(2) as string
array1 will be IB'd but no more arrays after that on that line
The workaround is two lines:
Dim array1() as string
Dim array(2) as string
Example 2
Dim rgThis as range
and in code refer to
rgThis.Value
IB does not change it because in the case of Forms the control.value needs to be retained.
The workaround is to use
rgThis.cells(1,1).value