userform

  1. C

    Textbox to Textbox, Hyperlinks to desired browser, Reset CommandButton, Open another Sheet while UserForm is open

    Hello All, As the title says (i am not sure if this kind of title is allowed, kinda desperate for help), I have a few queries about my current worksheet. Below is my code for my checkboxes and comboboxes captions to appear on my TextBox3. Shoutout to @DanteAmor for these codes. What I want to...
  2. T

    Freeze userform position relative to worksheet

    Hello all, I have a spreadsheet (Windows 32-bit, Excel 2007) in which I have a userform successfully being placed where I want it (top left of cell B1). But the userform remains fixed in its initial position when I reposition the spreadsheet. I would like the userform to move with the...
  3. Y

    Barcode Scanning in the Userform (missing numbers.)

    Hello everyone my problem is a little bit annoying. When i try to scan a barcode in the textbox there is always number 7 is missing. for example if the barcode is 123456789 it writes in the text box 12345689 . The barcode scanner works perfect except in the userform. I tried in the notpad it...
  4. N

    [VBA] why is my match function not looping through correctly?

    I'm trying to locate a row # with data I need to update based on two text boxes within a userform. Code is here: Private Sub cmdSendData_Click() Set wb = Workbooks.Open("\\TABLE.xlsx") Dim wsTgt As Worksheet: Set wsTgt = wb.Worksheets("Sheet1") Dim recRow As...
  5. J

    Export Date from text box in userform to dtpicker in sheet

    Hello! i'm having trouble linking a Date box from a userform to a dtpicker in sheet (because i need the dtpicker with calendar available if the date is to be altered). I have tried this code, but obviously it didn't work...DATE1 is the box in the userform and DTPicker1 (from the development...
  6. N

    Setting a userform combo value from a worksheet cell value

    Hi my first post so sorry, I have a userform with a few combo boxes on it three of them I can update the values but one will not update. Its the only one that triggers some code but I am happy to run the code after. Me.TextBox1.Value = Range("E14").Value ' works fine'...
  7. L

    Pass data from a userform to a variable within a macro

    Hi! I'm working on a macro which graphs columns selected with an input box, and I'm trying to change these input boxes to userforms (in order to decrease the amount of popups for the user). However, I'm unsure of how to assign cells selected in a userform to variables which can be used in a...
  8. B

    Dynamically Create and Fill Value of Userform Textbox in VBA

    Hi Community, I am stuck in a VBA conundrum. I am trying to create multiple UserForm Textboxes in vba and Fill each one with a unique value either by index, or by some other means. I am able to get them to fill but when I do it seems that all the text boxes are being filled with the same values...
  9. M

    UserForm not finding multiple entries

    I was looking for a code that will help me look for multiple/dupes in a worksheet when entering information from a userform. I struggled with this and searched google high and low and used the code: If IsError (Application.Match (Me.NameTextBox, Worksheets("Admin").Columns(3),0)) Then MsgBox...
  10. R

    Auto generating invoice number based on invoice number on last row

    So, I have a userform and a database file, the format of the invoice numbers(which act like unique serial numbers) in the database goes like 001/2020, 002/2020, 003/2020 and so on. With the help of Userform_Initialize, I am auto populating the invoice field in my userform. So if last invoice is...
  11. A

    VBA, Userform, Search Function show result for Referance number in text box, would this to also select corisponding row in list box.

    Hi all, Fairly new to VBA. I have a userform that allows you to enter Clients Information into text boxes and add this data to a table in excel. You can then search by Customer Reference no. to show results in textbox they were entered to update etc. I also have a list box that shows all...
  12. lockarde

    Hide a Userform when clicking outside the userform?

    Hello All, I have a simple userform that pops up and shows a quantity breakdown of categories in a worksheet. I was wondering if there is a way to make the userform close simply by clicking away from it, similar to what would happen if a pop-up appeared on a webpage. It certainly isn't a...
  13. Y

    Populate userform textboxes and comboboxes

    Hi all, Hope you can help me with below issue. Thank you in advance. Context I have a userform that requests the name of an entity. Once the name is entered the user can choose to collect data (if any). To do so I have created a button. Once clicked the idea is that other elements in the...
  14. C

    Userform Data Mismatch issues

    I Have created a user form that auto populate fields 2-11 with data from the range on sheet1 ("Data12"). all of this is based on the Serial number inputted into form field number #1 which is a dropdown list that uses the range in colum 1 of the sheet which holds all the other data the only...
  15. P

    Change column in multi-column listbox

    Hi. Not sure this is possible, but here goes: I have a multi-column multi-select listbox. It's populated from a dynamic range on a sheet (width of the range does not change but number of rows does). The listbox is on a userform with a submit button that write values from the form to another...
  16. Q

    Creating Change Events on Dynamically Created Textboxes

    Hello all, I hope this finds you all healthy and safe! I have a Userform where I have populated some textboxes in Design and others dynamically. For the textboxes that I have created dynamically, I need to populate the Change event with code to run a routine in a module. I'm creating the...
  17. D

    Userform Listbox Not Returning Selected Value (.Text)

    Hi all, I have a Userform with two Listboxes and two Labels on it. Both Listboxes are populated in the Initialize procedure and one item is selected in each as a default when the user launches the Userform. I would like the Label1 to show the item selected in the Listbox1 and Label2 to show...
  18. D

    Find missing checkboxes in userform

    hi all, The following code showing my userform contains approx. 170 checkboxes. Sub macro1() Dim ctl As Control Dim j As Long 'Dim msg As String j = 3 For Each ctl In UserForm1.Controls If TypeOf ctl Is MSForms.CheckBox Then If UserForm1.Controls(ctl.Name).Value = False Then Cells(j, 5).Value...
  19. P

    Populate a Userform Caption using a Named Range

    Hi All, I'm new to VBA so hope this question isn't too dumb! I'd like to add a "Key" to a user form that can dynamically update should it need to. Currently the user form has a number of comboboxes which have shortened codes in them to make entering the data faster, and so the resultant...
  20. Z

    VBA - Userform - dataform into excel attachment

    Hi all, Wandering if anyone can point me in the right direction. I created a vb userform for people to input data. It is basically a bunch of fields, then the vba macro will create an email with some pre-defined settings, and then put the data in the email as a table and then send to...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top