textboxes

Hello all, I have a combo box on a userform set to a specific range. Whenever the user selects a value from within the combobox, I need the values of 26 textboxes within the same userform to populate numbers based off of a Table (Table7) in Sheet1. Can you provide assistance with this?

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

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

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

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

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

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

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

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

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

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?

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 :)

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

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

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

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

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.

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

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

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