Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for that.
Geoff "Chip Pearson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ActiveControl problem | Excel Discussion (Misc queries) | |||
Calendar Control & ActiveControl | Excel Programming | |||
userform1.activecontrol.name | Excel Programming |