userform

  1. lockarde

    Make userform open at specific cell

    Good morning all, I have a macro that runs when a user double-clicks a cell. Among other things, this macro opens a userform. Is there a way to make the user form open to the right of the double-clicked cell every time? The location of this cell moves down the sheet as the user activates the...
  2. B

    How do I get a userform to refresh information that changed in the spreadsheet when it is reactivated by userform1.show

    Greetings everyone... Longtime viewer but 1st time poster. Hopefully this will make sense... I have a userform that tracks who gets a project revision when the person the project belongs to is gone (this part works great). In this userform there is another userform that allows me to alter the...
  3. A

    Change Event for Multiple Check Boxes

    I have 25 text boxes named in the following manner on a UserForm Name: id_[X]_box 1<= x <= 25 I am trying to write a program which can register a change event for all 25 boxes and populate the corresponding [DESCRIPTION] Labels. Naming scheme for Description Labels Name: desc_[X]_label 1 <= X...
  4. E

    2nd Userform not populating information

    Hi All, I am very new to excel VBA (Came acrros this function 2 days ago) and as such i am really lost as to how to fix some things. I have been able to get everything working except for a couple of things and I am so stumped on how to fix these :( I have a button in my worksheet to open the...
  5. D

    VBA Code to see if criteria in a user form matches to a row in a table

    I'm trying to use a form to match criteria in entered in a user form to a row in a table. If box1 value is found in the table and the value in box2 if found in the cell to the right of the value in box1 and the value in box3 is found in the same row as the first two boxes values, then I want to...
  6. D

    Opening PDF & JPG files with USERFORM VBA

    Hi I have googled my heart out over the last couple of days and tried 100's of different things but nothing is working so I am hoping one of you fine people can help. I have created a Database with a user form. I need to be able to open the files which names I have pointed out on the left hand...
  7. C

    VBA Issue - Adding values to empty rows using userform

    Good Morning everyone, I am having issues with VBA (I've probably coded it wrong) however my intention is as follows: Press New Person Button Add details for new user (using UserForm) Details will populate into cells A8 through to G8 from the information collected in the userform Each entry...
  8. K

    Procedure stopping after first line of code

    Hello, I'm messing around with Userforms and have been trying to get all the values of textboxes within' my Userform to save and match up with what's in the worksheet its supposed to be editing. I took a very basic approach to this and have the start of my code looking like this : Private Sub...
  9. P

    Some Users get VBA error 91 after call Userform with TextBox related to sheet

    Hi, I have this problem with code on some PCs (Error 91). Code is used to give user splash screen after start of workbook - where is classical EULA conditions located with button Accept and Decline. I have problems to call Sheet named EULA, which have the text for the Userform TextBox. Where I...
  10. B

    show Userform when Activecell in table Listcolumn range

    I have an excel table that a user works in and inputs data. When the user tabs (Or Clicks) into a particular cell within a Particular Column of that Table I would like for a Userform to Automatically show and if the User Tabs (Or Clicks) away from that column for the Userform to close...
  11. K

    Validate multiple text boxes to accept only numeric values

    Hello experts, I am quite novice to VBA and any help from you would be highly appreciated. I have 44 text boxes in my user form which I need only to accept numeric values. Every text box name has a "Quantity" part (ex. InhouseQuantityTextBox, PurchasedMaterialQuantity,etc.), but, they are not...
  12. J

    using userform to populate Table1 on spreadsheet

    Hello everyone, I have been researching and researching with building userforms and their reactions with the spreadsheets. I came across so many different ways to accomplish the same thing. It's crazy how many people do this differently. So I came out with this fully functioning coding that...
  13. K

    Filtering column for input in ListBox

    Hello everyone. I have a document with a userform that allows users to select a specific area in a list box. Multiple selections are possible. Based on the input I would like to filter column E called "AreaColumn" for the input made by a user when cofirming the user form with OK. So far I've...
  14. F

    Function count if for text in textboxes VBA Excel

    Hi, I am doing a userform where I have 8 textboxs named ddc, example: ddc1, ddc1...ddcn. then I have another textbox name quantcoup, that is the textbox I want to receive the count if of everyone of the ddcs that have text in it throughout a command button. Also, I want that the count if detect...
  15. S

    Line-breaks in Userforms freezes Excel

    Am using userforms on a spreadsheet to populate content to cells within a worksheet. The links are working perfectly and the data is being copied across precisely, from the userform to the cell and visa versa. However, when a line-break is added (ALT+ENTER on the worksheet / ENTER on the...
  16. N

    Show different value in ComboBox from selected list

    I have a ComboBox (Quart1) in a userform with the ff list of items added at Userform Initialize: Private Sub UserForm_Initialize() With Quart1 .AddItem "Q1 (Jan to Mar)" .AddItem "Q2 (Apr to Jun)" .AddItem "Q3 (Jul to Sep)" .AddItem "Q4 (Oct to...
  17. G

    Formula to Calculate Business Days

    Is there a formula I can use that calculates business days. Or a way to get this link to work right and autopull in a userform without errors: https://www.calculatorsoup.com/calculators/time/date-day.php Or... is there a way to set a macro to auto pull this link via Chrome as a new window...
  18. D

    Change UserForm dynamically based on input

    Hi MrExcel, I'll greatly appreciate your input re the issue below. I'm looking for an option to add elements (such as ListBoxes) to a Userform in a dynamic/interactive way: the number of ListBoxes (as well as their names, tab indices etc.) should depend on a specific input value (say, on the...
  19. J

    Error Handling Help

    I have what is probably a simple error handling issue for most of you but I can't seem to figure it out. I have an excel userform with multiple text boxes that auto populate via a vlookup. This all works fine except for one text box I can't seem to get the error handling right for. I need a...
  20. S

    Calculating Time Units - VBA User Form

    I have code that will calculate time elapsed and how many 15 minute units are between the two times entered. It was later decided that an user form may be the more appropriate approach for my audience but I have 0 experience with user forms. I made an attempt but I can't figure out how to make...

Some videos you may like

This Week's Hot Topics

Top