View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Determine ActiveControl on a multipage (tab) control

Sorry, I probably wasn't clear enough.

I've got a bunch of textboxes on a multipage control. Have a function
that
I want to work based on the "ActiveControl", but when I run the following
code, it indicates that the "ActiveControl" is the multipage control,
rather
than the textbox that actually has the focus.

I need to determine which textbox has the focus.


I think this will give you what you want...

MultiPage1.SelectedItem.ActiveControl.Name

Rick