userform

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

HI, I'm trying to write a simple loop to pull data from my worksheet into a text box on my userform when I click a command button. The data is all in one column, but it could sometimes only be 3 rows, or 10. Once I get the data into the text box I want it formatted like this: "Data from...

Hey, I want to save two different ranges into a PDF document. One range for each page. The first range is Worksheets("Data Storage").Range("$N$4:$P$20") = Range for First Page The second range is Worksheets("Data Storage").Range("$Z$32:$AG$97") = Range for Second Page (The Range in Macro...

Hi all. Our business is moving away from a third party that looks after our sickness. Whilst we await another (possibly), I have been tasked with creating an interim solution. What the powers that be have asked for, is a central user form that can populate a selected Workbook. As we have...

I tried a few code snippets for scrolling a userform with mouse wheel. So far this has worked. How to use the mousewheel with a scrollbar control Is it possible to allow scroll only when mouse hovers over the form? - 64-bit - Form is vbModeless

Hello, I've got an issue with FIleCopy command in VBA. I always used this when i wanted to copy/paste some file from one folder to another. (but it was local or based on the server). Unfortunately at that moment i have to wokr with onedrive solution. I need to build some file (or rather wanna...

Is it possible to recall the value selected (highlighted blue) in a userform listbox when form is shown again. Below code uses arrays to show subfolders in a listbox. Option Explicit Private Sub UserForm_Initialize() Dim file_system As Object, sub_folder As Object Dim main_folder As String...

I have a column B that contains the date, and a column "i" that contains incoming values, a column" j "that contains spent values, and a textbox1 contains a date and a Textbox 2 is required to show the result of collecting column cells, "i". that are smaller than the date in textbox 1, as well...

I am wanting to have a userform which brings in my information from the user and then outputs it to a spread sheet but I can't figure out how to get it to output in 2 decimal places if the user does not put in the value with any decimal places. I want it to always output to 2 decimals regardless...