textboxes

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

I need your help please I have 4 textboxes in a userform. I need to run a loop to go through each box and check if it contains a number greater than 0 and add rows to a table accordingly. summing up all textboxes together is not option.

I'm not sure if this can be done or not. I have dug through the threads and google looking for code. I have multiple rate sheets that are named by client. On the sheets are the equipment we are going to use along with the rates we are going to charge. I don't want to just copy and paste the...

Hi All I have created a (time sheet) userform with 7 textboxes each representing a day of the week (Monday – Sunday). I have a further 4 textboxes for the Daily Rate, Gross Pay, Tax Paid and final ‘Net Pay’. I have restricted entry in the 7 textboxes to 1 or 0. - 1 for a day worked or 0 for a...

Hi, I have a VERY simple working Userform that looks up the first of three columns (of a Victorian postmark database, in Sheet "England") and populates the remaining two Textboxes after manually inputting TextBox1 (a number). So, for example, if I typed 123 into Textbox 1, Textboxes 2 and 3...

Can anyone help with what I thought would be an easy job? I would like to populate 13 TextBoxes (101 to 113) with data held in a range of cells. The following formula does the trick on a single box, but I'm going to end up with maybe 100 or more boxes to do. TextBox101.Text =...

Good afternoon, I have a userform with multiple tabs in a multipage object. I completed the project, and all was working as intended. On each tab, there are multiple textboxes that feed into corresponding listboxes via the textbox exit event. Since completing the project, I decided to add...

Hi there, I have a few dozen textboxes on a userform, might add a few, might take a few away. Looking to change the backcolor of them all. My first question is: are textboxes counted as controls? So I'm trying to write using the following code - any ideas? Dim ctl As MSForms.Control For...

Hi all really hoping for some help. I would like to transfer a row of filtered data from my worksheet (Sheet1) into corresponding textboxes on a Userform. I would like to do this automatically by means of the Listbox- doubleclick event. Currently: – I have a listbox (named: lstLookup) which...

Hi Everyone, I remembered working with If TargetAddress which works with pointers. It really amazing using it to do manipulating since all you do is just use a tab key or arrows. I wondered if this can be applied in a userform. My case: I had a userform with many textboxes of around 60. All...

Hello There are about 50 textboxes in the userform i created. Everytime time i added a new textbox, I have to re-order the textbox to textbox1, 2,3,4...and so on. I have to do it each one everytime i added a new one. Is there an easiest way to set the textboxes in reorder all at once? Thanks

I have a macro that rescales 60 charts and adds in a historic date to a textbox in each chart. When I run the macro to update the sheet it over writes another textbox over the existing one (some now have 10+ as I didn't realise this was happening as I had the following at the start of the macro...

Greetings, just wondering if something is possible. I have used VBA to send emails containing the contents of worksheet cells, but I have never sent an email from a userform before. Has anyone ever tried to send an email from a userform where the email would contain the values from some of the...

Hello All, I have this challenge here: i wanna find out if what i am thinking is possible. Then after that i need help with it. So i have a textbox called txtCurrentUser and in this textbox i have username in it. Now i wanna write a script to look at the txtCurrentUser, counting from the left...

Hi, I want to add data from multiple textboxes to a sheet that. The form has multiple lines containing product data, like part, description, location, qty It also has a textbox where you can enter the qty you need and txtQtyAdd If the txtQtyAdd textbox contains a value it should copy the data...

Hey all, I have a userform with many textboxes, similar to a questionaire. I need these textboxes to go to their specific locations in a PDF file. How can I do this? Devin

Hi Guys I have 6 textboxes going across and this is repeated 10 times down my userform. The textboxes going across are in chronological order. The row of textboxes will populate when the user selects their choice from a combobox and click on a button. It will populate to the next row of...

Hi, I have a userform where you enter currency values into two text boxes (tVALUE & tVAT). Upon adding values it should update a label (lTOTAL) with the sum of both text boxes. The code works but I can't get decimal values to show up in lTOTAL, it always shows "value,00 €" and I can't...

I'm having a weird problem: If I add a new textbox to an existing form in Excel, I cannot enter a space character in that textbox. All the other characters seem to work. I've tried making a copy of an existing textbox that does work but the new copy won't allow spaces either. So, a new...

Hi All, I am currently putting together a stop-gap time booking tool. I am using a userform for this. Users will be able to add new lines, consisting of time entries for each day, against booking codes. The number of lines needs to be dynamic. The user presses a command button to add a new...