frame

  1. L

    VBA to loop through activex frame controls

    I have the following code to loop through a series of activex checkboxes in a frame. I then want to pass the strReportName variable into other subs and functions. When I hover over strReportName in the code, it is listing the correct string, but when I set a watch for this variable, the value is...
  2. M

    Clearing values of Different control type inside a frame with vba

    Hi, I have a user form which includes two frames one is header and the second is "body". Each has text box and combo box controls, I want to clear all the content of body controls, no matter of the control types. Also, I need to know if I add for instance radio button How I should change the...
  3. J

    Text boxes / frames of equal size and variable content

    I want to add a set of rectangular text boxes / frames all the same size, but with different amounts of text. I'd like to have the box / frame accommodate the additional text by converting it to a scrolling canvas, scrolling within the text box / frame. I do not want the remedy for too much...
  4. A

    Dynamically add a Frame within a Frame

    Hi, I have been trying to create a runtime frame control, which I am having issue to create within another existing frame. When I am adding a frame to the Userform Set cCont = Me.Controls.Add("Forms.frame.1", "NewFrame") its working fine. But the same is not working for the below code Set cCont...
  5. A

    VBA Excel 2010: error 438 on exiting last text box in frame

    Hello all, This is a problem I think I've encountered before but cannot remember the solution to. Situation: I have three text boxes in a Frame, on a form. The user enters date values in each text box and clicks a button. The code is supposed to check the entered text, swap out "." for "/"...
  6. E

    Is there a way to display a message on a frame without the msgbox in VBA?

    Hi All, Iam wondering.. is there a way to display just the message without the msgbox (preferably on a frame :)) so that the user will just view the message and don't need to close the message like it happens with msgbox? Ps: formatting of the text displayed would be good too...
  7. M

    SUM textbox Values within frame

    I set up a grid of 12 x 12 textboxes within a frame, so (144 individual boxes) that allow a user to input a number. I was unsure if there was another way of summing the values together in that frame without doing, Val(textbox1) + Val(textbox2) + Val(textbox3)... Also, this is all within a user...
  8. I

    Passing values to Frame Textboxes From Excel Sheet using VBA

    I have put the Frame Control on Excel Sheet and Add Textboxes and Labels to it . Now I want to Send data to Frame Controls(Textbox) from Excel Sheet By a Click of a Button. What is the Procedure to do it? Thanks in Advance
  9. S

    VBA to add a TextBox to UserForm1.Frame4

    I have made a Userform with 3 Frames. The final frame includes an OptionButton. If clicked a fourth frame is added. I want to be able to add some textboxs and labels to this frame. I have the code to add them but they go to the userform instead of the frame. I have searched for the answer on...
  10. H

    Frames question

    Hey So I have a frame with 5 or 6 text boxes. Right below this I have another frame with 5 or 6 more text boxes. The thing I want to do is, if you are entering any text in any of the 5 or 6 text boxes the frame should change its background color to say red. Now if you go to the next frame the...
  11. L

    View of window from another sheet

    I am looking for a way to have a view / frame of another sheet that is that stays on top of an existing sheet. For example, if I have variables in Sheet B, I would like a sizable frame from Sheet B to stay on top of Sheet A so when I change variables in the frame of Sheet B, I can watch Sheet A...
  12. J

    Xcelsius viewer in Access

    Hello, I have a Xcelsius file that I would like to display in Access but need some help. I have tried a couple different ways to export the Xcelsius file so that Access could pull it in but no luck. I exported the Xcelsius into .doc and .pdf and tried to add an Unbound Object Frame to an...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top