Thread: ActiveControl
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default ActiveControl

Try

MsgBox Me.MultiPage1.SelectedItem.ActiveControl.Name


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Geoff" wrote in message
...
On a form I have a multipage with a number of pages and
controls.

I cannot get ActiveControl.Name to return the control with
focus as this
only returns "MultiPage1". MultiPage1.Page1.ActiveControl.Name
has no effect.

What should the correct syntax be to address controls on Page1
of MultiPage1 ?

Geoff