Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveControl
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
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveControl
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveControl problem | Excel Discussion (Misc queries) | |||
Calendar Control & ActiveControl | Excel Programming | |||
userform1.activecontrol.name | Excel Programming |