frame

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...

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

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

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

Howdy So the project I'm doing has me at a crossroads. The PERFECT candidate for what I'm trying to achieve is a Frame control. It's isolated, scrollable... it's just that in a worksheet they're the devil. Simply trying to add one at runtime throws up odd exceptions and bugs ("Cannot enter...