textboxes

  1. B

    Create a single handler for multiple textboxes

    I have a UserForm with a large number of similarly named textboxes. A DARTS Scoring System. In fact, I've created a userform that mostly duplicates the SpreadSheet function Using a spreadsheet is, I know, by far the best for this, but I was curious to see if it was not only feasible but...
  2. R

    Formatting multiple Textboxes in UserForm

    Hi all, I have a userform with 50 textboxes (textbox1, textbox2, etc) I want to format all of them so that way after the user types in a number, the number formats to the thousands, Like if they type 1000, it’ll show 1,000 on the userform. How can I do this efficiently so I don’t have to go...
  3. T

    Auto-Update Userform Label when text boxes change values

    Hi all, I have a userform with 18 textboxes, all set up to only accept numbers. I have a label that is set up to display the sum of the 18 textboxes, and have the textboxes and label set up to read any empty text boxes as "0". I am looking for a way to have the label automatically update when...
  4. P

    Vlookup in VBA?

    Hi everyone, First, I'd like to thank everyone who previously helped me and now I'm back to ask for more of the expert's suggestions and help. I am currently working on a mini project where I aim to use Buttons, Textboxes in VBA to do a 'vlookup', that if... it's possible. So here's how it...
  5. R

    2 words in A Cell split into 2 textBoxes on userform

    I always start my new thread as "I have this sheet" or "I have this userform. I am not going to do that today.. lol I am going to start by thanking all of you and your contributions to helping me learn and understand VBA. I took this project on that it might be over my head a little bit and...
  6. A

    Userform multi tabs

    Hi all I am unsung Excel 2013. I have an userform with textboxes. I have created some multiple pages underneath the main userform textboxes. However when I click the tabs in the multi pages, the screen moves and only shows the content of the multi pages. I would like to keep the main form...
  7. A

    Loop Through A Series of TextBoxes in a Userform

    I have a userform with a series of 8 textboxes each holding a unique value. I am looking for code that will step through each one of these 8 boxes to gather the value so that I can use that value in further code. I am not sure how to set up a loop referring to the 8 different textbox names...
  8. B

    how to calculate textboxes in a report?

    I have a report with 7 textboxes that are populated from a query. I have created a 8th textbox where i want to sum up the textboxes. the first 7 textboxes are short text in the table. the 8th textbox i want to write a formula so it takes the current value of the 7 textboxes and show me a total...
  9. Stridhan

    Userform events

    Hi Got a simple userform with textbox1, textbox2 and a commandbutton. Using the Exit event on both textboxes to do a check if they are empty or contain invalid data, if empty or invalid data the textbox gets the focus. However, when both textboxes are empty I want to have the option to press...
  10. sharky12345

    Loop through Textboxes

    I have 5 textboxes on a userform and I want to evaluate if they have text entered. The values are used as a 'CC' list for an email message, so I also need a semi-colon added after each textbox. Can someone show me how this could work?
  11. A

    VBA - Userform match two columns

    Hi Guys, I'm just starting to learn VBA and I'm wondering if anyone can help me out. I'm trying to match two words in two different columns, if they match then use offset to populate some information from textboxes to the right. Is it possible to match two? Any help will be much appreciated :)
  12. A

    Problem With VBA Formula To Determine Difference Between Two Times

    I am trying to populate a userform textbox with the difference between two times found in two other textboxes of the same userform. Textboxes cu2_start = "7:00 AM" and cu2_end = "15:00". I am looking to populate cu2_hours with "8.00". I have this line of code .cu2_hours.Value =...
  13. R

    Format Multiple Textboxes with One Code

    I have several textboxes that I want to format as currency, and several others that I want to format as date (MM/DD/YY). When I say format, I'm referring to displaying the desired format in the textboxes themselves. I realize that I can format the textboxes individually, but I'm curious if...
  14. B

    Error when calculating blank userform textboxes

    Hi all, I'm using the following, but get a run-time error if any of the kg# user form textboxes are blank: Private Sub convert1_Click() Dim ws As Worksheet Set ws = Worksheets("Blends") If fert_rate.Value = "" Then Exit Sub ws.Range("h22").Value = fert_rate ws.Range("r9").Value = kg1.Value /...
  15. J

    Passing data to a variable number of TextBoxes in a user form

    Hi all I have a user form which can have up to 10 Textboxes. These are numbered Tbx1 through to Tbx10. The user inputs a value into a seperate textbox upto a maximum of 10. For the purpose of this example, lets suggest a value of 5. The code then needs to populate Tbx1 to Tbx5 with same data...
  16. O

    Restrict All Textboxes which are in a frame to Allow input Numbers only

    Hi.. i have a user form Named"Form1" in this form i have 2 frames Fr1 and Fr2 in fr2 i have 10 textboxes.. i want to restrict only Number value in all text boxes of Fr2 how can i do it.. thanks in advance.
  17. lumch

    UPdate value on sheet cells from textbox on userform

    Hello, I have this code that transfers data to a sheet and creates a data base of : Name, DOB, Phone number, Insurance name, Insurance ID. Dim strDataRange As Range Dim keyRange As Range Set strDataRange = Range("A1:h5000") Set keyRange = Range("A1:h5000") strDataRange.Sort Key1:=keyRange...
  18. P

    userform woe's

    Hi Thanks for taking the time to look at this and any help given. So I have a contacts userform which has various multipages, frames, tabstrips and textboxes on it and it worked great, the problem I am having is one of the frames which has textboxes in it is now causing the form to crash, if I...
  19. D

    Updating Cell values via Userform textbox (issues)

    Hey All, I have a user form for tracking orders i need to follow up on. When the status of the order changes I update the sheet via the same form I used to submit the data initially. I have an "update" button to do this. The problem i'm having is, if the information is being offset by 1 based...
  20. D

    I have 6 textboxes on a userform but require only 1 entry.

    Hi, I have 6 textboxes numbered 2-7 on a userform. I only want 1 with a value in when I press the command button to transfer the value to the worksheet. If there is a value in 2 or more I'd like the textboxes cleared and a message saying "only one textbox value please" any help would be...

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