ActiveControl - Return non-Multipage control when Form contains Multipage?

Hello All,

I have just started learning ActiveControl and have run into problems. I have a form which (amongst other things) contains labels and a MultiPage. I want to use ActiveControl to detect which label was clicked instead I get "Frame_MultiPage". So I searched the net and found this http://social.msdn.microsoft.com/For...forum=exceldev however this code doesn't do what I want - now I get "MultiPage1".

I don't want to return the Multipage or any of the controls inside the Multipage. I want to return the label clicked. Is there anyway to do this using ActiveControl?

Why don't you try the ActiveControl of the frame?

Also, you might want to look into using classes.

Originally Posted by Norie

Why don't you try the ActiveControl of the frame?

There is no Frame around the labels.

Sorry, meant multipage - confused by name I think.

Originally Posted by Norie

Sorry, meant multipage - confused by name I think.

That's OK.

The labels are outside the Multipage. When I use the code from the link provided in the OP, it only drills down further into the Multipage. I want to detect the ActiveControl for controls outside the Multipage. :S

Perhaps the problem is that labels can't take focus, so they are never 'active'.

Originally Posted by Norie

Perhaps the problem is that labels can't take focus, so they are never 'active'.

Ah daylight :facepalm:. Thanks Norie +1

This thread is solved by Norie.

I now need an alternative solution to using ActiveControl... http://www.excelforum.com/excel-prog...procedure.html