I'm wanting to use this to get the caption of the current Frame item
But it's not the active control. It's a frame called "frmSheet" I've tried various combinations but all result in Type Mismatch error.Code:Dim C As MSForms.Control Set C = Me.ActiveControl If TypeOf C Is MSForms.Frame Then Set C = C.ActiveControl Me.Tag = C.Caption
What would be the correct syntax for Set C= Me.frmSheet