1. V

    Listbox to insert data to selected line

    Hi currently I have a userform with a listbox that displays the data I've selected in textboxes but whatever code I try to insert the new data to either the listbox or cells of the highlighted line in the list box I get error "70" listbox does not have permission.
  2. J

    Copy data from lastrow to first empty row on new sheet created

    Good morning all! I've been trying to used multiple posts for reference, but i'm stuck on the last piece of code to make this sheet work. When i create a new sheet, based on the submission of data through a userform, it should also copy the data to the new sheet created (to automatically start...
  3. C

    Keep UserForm on Top (Office365, 64-bit)

    Hello All, As the title says, I have around 7 UserForms and I want them to be always on top of ALL windows once opened. Currently, I had set the ShowModal to False on the UserForm properties. My issue is when I minimize Excel, it also minimize the UserForm. Details of the file: • Office 365 •...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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'...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics