frame

  1. M

    Controlling frame order

    When you have 2 frames in a userform overlapping, how do you control which frame is on top?
  2. M

    passing a frame name to a subroutine

    I'm trying to create a subroutine (actually two) The first finds the coordinates of the frame and stores the value, then sets the values I need to explode the frame size. Sub displayframe(frm As msforms.Frame) With frm ht = .Height wdth = .Width Tp = .Top lft = .Left...
  3. R

    Move a Frame in a Userform to a different page

    I know how to move a frame in a page i.e. Frame1.Top = 100 What I want to do is move it to a different page Tried Frame1.MultiPage1.Pages(3).Top = 100 but it wouldn't work Thanks
  4. E

    Retrieve a value of a frame

    I created a frame in a userform, this frame have two option buttons and two text boxes. I want to retrieve the text in the textbox that corresponds to the selected option button. How can I do this? Thanks
  5. C

    Dynamically Expand a frame within in a form

    Hello All, I've search for hours to this solution but to no avail. I have a big user-form that have text-boxes dynamically appear when the user press the add command button. This sits in a frame called frame1, I was wondering if it could expand with the amount of text boxes that are on the...
  6. L

    VBA - Click menu button in Frame

    Good Afternoon, I am new to this forum and also very new to VBA. For the past few weeks I have been trying to automate pulling data from a company webpage with no luck. I have got as far as logging on to the webpage, navigating a dealer select drop down and onto the main dashboard. The bit i...
  7. I

    Tab order on userform

    Morning, I have a userform as shown below. Text box 1,2,3,4,5 Frame 1 which has 3 option bullets inside say A,B,C " I expect to tab through A,B,C left to right" Frame 2 which has 3 option bullets inside say X,Y,Z " I expect to tab through X,Y,Z left to right" When i tab through a live form the...
  8. D

    Creating Heat Map - Round down to the 30 minute intervals

    Hello, Need some help trying to figure out why when I create a heat map from different timeframes that I'm only getting ":00" and ":30" and not 8:00am, 8:30am, 9:00am, 9:30am...etc. I'm using the formula =FLOOR(N2,"0:30") to round the timeframe to the half hour. I'm sure using "0:30" is...
  9. R

    Failing to use VBA to change color when conditions are met

    I've looked at several similar examples of the issue I'm having, but I'm still missing something. I want to change the color of a frame to red when a cell value is NOT "on hold" and when another cell value is either NOT "ND" or NOT over 100%. Otherwise, I want the frame to stay the original...
  10. R

    Userform Objects During Runtime

    Hello, I just started learning how to create objects during runtime and I am currently having a problem with creating multiple frames horizontally and I can't seem to line them up properly as each frames has their own width. Can someone help me out with creating multiple frames considering that...
  11. A

    Userform Frame Scroll

    Is there any way to scroll a frame on a userform when the screen used is a touchscreen? i.e. swipe to scroll, not tapping scroll bars.
  12. S

    Issue with checkboxes in userform

    Hopefully, I will explain this well enough for people to understand :)I have quite a complex userform. The issue I am facing is when clicking a checkbox in a different frame it is not ticking on the first click. It takes a second click. I think the issue is there are a number of procedures that...
  13. C

    update two stocks in every 5min/15min

    Hi I have excel files which contains Test Pair File and Live data file i want to update from Live data sheet to Test pair files every 5min time frame for ICICI & AXIS, NBCC & IRB as well as 15 min time frame for CIPLA & AUROPHARMA , BPCL & HPCL and also FROM "D" TO "P" columns are with...
  14. R

    Functions for getting a sum for a time period

    I am currently making a spreadsheet where the user can pick a time frame and depending on that selection, a function will sum up the time frame that the individual has selected. Currently, I have two data validation boxes that allow the user to pick the time frame but I cannot think of how to...
  15. S

    Filtered data in Listbox based on Option buttons EXCEL VBA

    Hello every one, I don't know about VBA or programming or any other language, I usually try to find solutions on the internet which fulfil my requirements and I use those solutions but this time I didn't find any thus I am posting here. I would appreciate and would thankful if someone please...
  16. M

    Drag and dropping the controls in a User form at run time!

    Hello, I want to develop a user form in which user be able to drag and drops the controls (Labels or Text boxes) from one specific frame to another frame. Can anybody helps me on this? Is this possible in VBA excel and is this handy? the actual project is bigger and have the login and log...
  17. P

    Dynamically reference framename from a single cell string value

    Hello. I'm afraid I have been searching a very long time but cannot find the solution. I have a userform with several frames. The frame names are stored in a worksheet table. When the userform is open, if the user selects a dropdown the worksheet table updates a single cell. Inside this...
  18. A

    Moving A Userform Frame To A Multipage Page In The Same Userform

    I have a userform. On this userform, I have a multipage control (multipage1) with 3 pages , the first page (value=0) named "MAIN". Elsewhere in this userform, I have a frame, named "f4_crew_review". I'm trying to code the run-time move of frame "f4_crew_review" to multipage1 "MAIN" page. If I...
  19. G

    Help with Frames in a Userform

    Hi everyone, I have a routine that runs more or less like this: In a Userform I have 30 Frames with CommandBotton inside. I want the routine to run From Range A1 to A30 of a sheet and if there is a 1 on that cell it means the cell is Active and the correspondent Frame on the USerForm should have...
  20. W

    Command button to perform multiple tasks

    Good afternoon all. In my userform, the employee has one field that populates from a drop-down menu the Month and Year time frame. This coincides with the tabs of the workbook (Apr 2018, May 2018, etc.). When the Save/New button is pressed, I need it to use the time frame (Apr 2018) and begin...

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