frames in user forms

[VBAmalta89]

how is a text box in a frame referenced in VBA code?

I know a normal frame is Me.frame1.x but i would like to call a text box within a frame as well if possible

 

[MickG]

Try:-

[COLOR="Navy"]Sub[/COLOR] MG14May32
[COLOR="Navy"]Dim[/COLOR] shp [COLOR="Navy"]As[/COLOR] Control
[COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] shp [COLOR="Navy"]In[/COLOR] Me.Controls
    [COLOR="Navy"]If[/COLOR] shp.Parent.Name = "Frame1" And TypeName(shp) = "TextBox" [COLOR="Navy"]Then[/COLOR]
            shp.text = "Jan"
    [COLOR="Navy"]ElseIf[/COLOR] shp.Parent.Name = "Frame2" And TypeName(shp) = "TextBox" [COLOR="Navy"]Then[/COLOR]
            shp.text = "Dec"
    [COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR] shp
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick