Okay, here is my next question...
How do I pass a Form Control Object to a processing function?
I have a comboList control that I want to enable with the following function.
Public Function Enable_List(ByRef whichList As ListBox)
whichList.Enabled = True
whichList.ForeColor = &H80000008
End Function
Now in my Form Code i have this...
...
With UserForm1
Enable_List (.comboListbox1)
End With
...
However, when I run my code I keep getting an Object Required error. Mainly, because I think the argument to the function call is getting "", which is the default value of the comboList, not the comboList Control Object itself. Does this make any sense?
So how do I get VBA to pass the object itself?