Controls (Control Toolbox): Placing controls in a F

  • Please can someone tell me how to place a control into a Frame control properly. I've tried and tried but as soon as I switch off design-view the controls are 'behind' the Frame.


    Help...!!?

  • Hi Ted,


    By Frame control, I assume you mean a text box? In which case, I don't think you can put anything else in there. You probably have to use a userform if you want multiple controls.


    .....Ralph

  • Hi Ted -
    Get into the Visual Basic Editor (Alt-F11), then from the insert menu, select UserForm. You can develop the form with any number of controls and text that links to cells on the worksheets.
    Then you'll need a macro to activate or display the userform like:

    Code
    Sub ShowTheForm()
      Userform1.Show
    End Sub


    Check the VBA Help files under "Userform".


    .....Ralph

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!