userform

I do not know if this is multithreading. But I would like to update my userform every 1/60th seconds when a long procedure is running. The structure of my code is something like this: VBA Code: Sub LongProcedure() LongProcedure1 LongProcedure2 LongProcedure3 End Sub Sub...

Hi all, I am currently working on a number of Excel files that use userforms. To help me understand what's going on, I want to be able to report all properties and their values for any specific user form in an open workbook. This line works fine (a user form in ThisWorkbook): Debug.Print...

Hi, I have a simple userform (for now!) that has two fields/textboxes on it that need to populate when a barcode is scanned. Problem I have is that I need to populate both with a barcode, mainly for speed, although a user could still type in if they wanted or needed to. One scan would be...

Having problems with userform setfocus after enter. Scenario userform textbox1 - textbox5 user enters data on enter of textbox6 a validation (i think this is what it's call) is ran. if the validation is not true then userform2 is opened and users enters data and that data is then sent to a...

Hey Everyone! So I am getting a bit stuck here - I have a timer that works (for the most part) the issue is when the userform is hidden and re-opened the "Continue" feature doesn't work anymore. Meaning the timer doesn't continue counting. Hope I can get some help please see my code below and a...

Hey everyone, hopefully a simple question - can I code a way for the [x] button to Hide the userform instead of unload/reset my code?

For multiple userforms, to call a procedure for the first time within each userform, I would prefer not to redeclare the procedure in those userforms. What ways can I avoid this?

I've got a user form to run a code depending on what kind of data I need to upload: Private Sub UserForm_Initialize() 'Reset the form radiotempl1.Value = False radiotempl2.Value = False datatype.Clear With datatype .AddItem "Public" .AddItem "Private" End With radiotier1.Value = False...

Hi all, I'm still very much a beginner when it comes to VBA but my intent is to find a way for a userform to access specific directories to allow the user to select a pre-sorted file. Below is a very rough draft of what my userform would be displayed as: In this example, the user would have...

Hi all. I have the following code to get the selected controls on a userform's designer module. The problem is that some controls are within a frame, in which case the frame itself is added to the collection instead of the selected controls inside it. I expect a similar problem to occur when...

Here is my code, first off: Sub namelookup() SalesForm.BHSDTAPNAMELF.Value = Application.XLookup(Val(SalesForm.BHSDMAINNUMBERLF.Value), Worksheets("NICK TAPS").Range("S:S"), Worksheets("NICK TAPS").Range("T:T"), Application.XLookup(Val(SalesForm.BHSDMAINNUMBERLF.Value), Worksheets("CB...

Hello Excel Gurus, For backround, I have an excel table that lists Mitigations related to a risk Item and it is as follows: Risk No. Mitigation No. 1001 1 1001 2 1001 3 1002 1 1002 2 1003 1 1004 1 1004 2 1004 3 1004 4 I designed a userform that allows users to update...

Good Morning, It's possible to print a Userform on Mac? I try Userform1.PrintForm but it doesn't work Thanks

I'm looking for a way to add something like this in my UserForm. A long time ago, I used to use an ActiveX component that would let me build a grid. But that stopped working like with Excel 2010. This solution has to run on Windows and Mac (and probably in the browser, too), so no...

Private Sub cmdClose_Click() End End Sub Private Sub cmdSubmit_Click() 'Priority Options If Pri1.Value = "True" Then Worksheets("Procedures").Cells(lastrow + 1, 2).Value = Pri1.Caption End If If Pri2.Value = "True" Then...

Hello all, I have the following UserForm and would like to only show ListBox results for the employee that is selected. Here is the current VBA code I am using to populate the list box: Sub AnalyzeEmployees() Dim DataTable As ListObject Set DataTable =...

Hi, I have an excel sheet with a cell (C1) formatted to hh:mm I have then created a userform with textbox1 and essentially want to add hh:mm to the textbox and have it add to the hh:mm already in cell C1. I am currently starting at 00:00, the cell is formatted correctly, but every time I...

I am creating a UserForm that is pulling records of my customers from a worksheet to my UserForm using this code: ``` Sub employeelookup() SalesForm.BHSDEMPLOYEETD.Value = Application.XLookup(Val(SalesForm.BHSDMAINNUMBERLF.Value), Worksheets("TELEDATA").Range("E:E")...

Hi all! I have a user form with lots of text boxes and spin buttons that work as a time picker. So one textbox shows value of spin button (from -1 to 25) for hours and other one shows value between -1 and 60 for minutes. Each of this spin buttons contains the same code: For hours: Private...

Hi all, I've created a UserForm calculator to remove the tax component from a value (I've posted about this once previously) but I've just struck an issue - it's working perfectly in calculating numbers based off a value up to and including 999.99, but anything 1000 and over it's not working...