<div>
Hi Ryan,<br />
<br />
Try this....<br />
<br />
&nbsp; &nbsp; &nbsp;Dim ActCtrl As String<br />
&nbsp; &nbsp; &nbsp;If LCase(ActiveControl.Name) Like &quot;multipage*&quot; Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dim pg As Page<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Set pg = ActiveControl.SelectedItem<wbr /><br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ActCtrl = pg.ActiveControl.Name<br />
&nbsp; &nbsp; &nbsp;Else<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ActCtrl = ActiveControl.Name<br />
&nbsp; &nbsp; &nbsp;End If<br />
&nbsp; &nbsp; &nbsp;MsgBox ActCtrl<br />
<br />
Regards,<br />
<br />
Wayne
</div>


Hi Ryan,

Try this....

     Dim ActCtrl As String
     If LCase(ActiveControl.Name) Like "multipage*" Then
          Dim pg As Page
          Set pg = ActiveControl.SelectedItem
          ActCtrl = pg.ActiveControl.Name
     Else
          ActCtrl = ActiveControl.Name
     End If
     MsgBox ActCtrl

Regards,

Wayne

<div>
Hi Wayne,<br />
<br />
Thanks for your reply.<br />
<br />
VBA doesn't use ActiveControl.SelectedItem<wbr /> is this a standard VB function?<br />
<br />
Horrible limitations with VBA :(<br />
<br />
Ryan<br />
<br />

</div>


Hi Wayne,

Thanks for your reply.

VBA doesn't use ActiveControl.SelectedItem is this a standard VB function?

Horrible limitations with VBA :(

Ryan



<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
In VBA I am trying to find a way to call the name of the active object within the form.<br />
<br />
Me.ActiveControl works for most part however if I have a multipage or tabstrip within the form the ActiveControl returned is always the multipage/tabstrip name, not the object contained within it.<br />
<br />
So if I am trying to call the name of TextBox1 within MultiPage1 how would I do this?<br />
<br />
Ryan
</div>
</div>


Hello all,

In VBA I am trying to find a way to call the name of the active object within the form.

Me.ActiveControl works for most part however if I have a multipage or tabstrip within the form the ActiveControl returned is always the multipage/tabstrip name, not the object contained within it.

So if I am trying to call the name of TextBox1 within MultiPage1 how would I do this?

Ryan

VBA obtaining active object name

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.