userform

  1. R

    VBA Timer

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

    Repurpose UserForm [x] Close button

    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?
  3. M

    Availability of a procedure for use by multiple userforms

    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?
  4. R

    Check that the options in User Form selected

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

    Conditional UserForm for opening specific folders

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

    Looping selected controls on a designer

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

    How can I use Application.XLookup across every sheet in my workbook?

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

    Populate VBA userform Drop Down based on an existing value of another textbox

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

    Print Userform on Mac

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

    Anyone have code to implement a grid on a user form?

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

    Data Transfer from UserForm using Radio Buttons in Frames

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

    Populate UserForm ListBox based on ComboBox Selection

    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 =...
  13. M

    Userform TextBox in hh:mm format

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

    I need to click a next button that will select the next value an XLookup would return.

    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")...
  15. K

    VBA Spin buttons in user form - how to declare them as a variable?

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

    UserForm calculator error

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

    Userform Loop

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

    Save Multiple Ranges in a PDF Document.

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

    One VBA Userform Feeding a selected Workbook

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

    Userform mouse scroll

    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

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