View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dmitry V. Petkun Dmitry V. Petkun is offline
external usenet poster
 
Posts: 4
Default How I can determine a base class of a procedure's incoming parameter?

1878026431
In VBA (Excel) I'm written procedure with an incoming parameter of type
Object. I need to determine which base class (not type) has this parameter.
How I can do it?

Public Sub FillControl(TargetControl As Object, SomeRS As ADODB.Recordset)
If [TargetControl is ComboBox] Then
TargetControl.AddItem "Item1"
...
ElseIf [TargetControl is Label] Then
TargetControl.Text = "Some text"
...
End If
End Sub

Thanks!

Dmitry V. Petkun