textboxes

I am trying to force the input of data into 2 different textboxes so that the user can't input an incorrect value or in the wrong format. The textboxes are on a userform and I need them to format as the user types so they are formatted as follows; In both examples, they should only be able...

Hello and merry Christmas to you (if you do celebrate it) I need help with this challenge : There are these 9 textboxes on my userform that I want to add values from six of them and place the result in the 10th textbox. Now these are the rules for the summing : 1. Add the first 4 boxes if...

TextBoxes 1, 2, 3 are intended for date of birth entry into a ws. The ws is formatted as Date mm/dd/yy ws.Cells(iRow, 4).Value = Me.TextBox1.Value & Me.TextBox2.Value & Me.TextBox3.Value TextBox entries = 05 12 52 Ws formula bar = 04/26/2040 I can’t figure out a workaround for this issue.

Hi Guys I have a userform with 3 textboxes on: TextBox1 = the user enters gross value TextBox2 = user enters VAT Rate as a number [not a percentage] TextBox3 = Calculates the Nett Value If I use this code: Private Sub textbox1_Change() TextBox1.value = Format(TextBox1.value, "Currency")...

My UserFormDataEntry uses 3 TextBoxes to add the phone number to the cell as ########## My worksheet displays the formatted phone numbers as (###) ###-#### How do I extract the numbers from the worksheet cell into another UserForm with 3 Textboxes? This doesn’t work: Me.TextBox4.Value =...

Hi, I was trying to search but couldn't find anything related to what I'd like to do. But then again, I'm still somewhat of a novice with VBA..... :-) Anyways....I have 4 textboxes that have the total overtime hrs. I'd like to add up the values/times from these 4 textboxes and get a Grand Total...

Simple VBA code to draw arrows, lines, textboxes and labels in userform

Hi all I want to use a select case instruction to change the colour of a series of active x texboxes based on their values, I've got that working for a fixed reference e.g. Textbox1 but I want to be able to cycle through the rest of the textboxes on the active worksheet. I've tried...

Good day! I have a Userform that pulls Number from excel and displays them in textboxes. I would like, within the Userform, to populate another textbox in the form of the largest number from the textboxes. For example, 3 userform textboxes display #'s Txt1 = 12 Txt4 = ABC Txt2 = 37 Txt5 = DEF...

Hi, I have 4 textboxes in a userform1. When I click in one of them textbox1_enter, I have a separate datepicker userform2 that shows and puts its value in the textbox. It took time but that works. My issue is that when I initialize userform1, I would like to have specific dates in the...

Hello, I have a userform with 6 textboxes to be filled by the user which will be used in generating a formula sheet, I need a validating code to perform duplicate check among all the 6 textboxes ,hope that was understandable..Thanks

Hello everybody! I want to loop through a worksheet which contains inserted TextBoxes. However, the "name" of TextBoxes don't follow each other in a logical way (not 1,2,3..., 100 and so on) It shows sometimes some skipp: 2-3-4, 6-7-8, 10-11-12 because of the paste) I try to skipp the textbox...

Hi! I'm stuck with my idea. I tried to figure out but seems complicated. There is an Excel table where there are TextBoxes inserted, something like: TEXTBOX empty row TEXTBOX empty row empty row TEXTBOX ... So the main thing is that there aren't overlapping textboxes. Is it possible to...

I've designed a userform using Frames. I'm new to frames and trying to learn how to utilize them. Right now I've got 4 frames (the number of frames will be 11 when I'm done building the userform), and each one of them has a different number of textboxes in them. In the UserForm1.Initialize sub...

Hi there, After some hours spend and not getting any closer to the solution I decided to login again and call in the troops. I understand how it works but not how I can make it work. So any help will be greatly appreciated. I have a couple of textboxes and comboxes which I would like to have...

Hi all, I have created a user form that allows users to fill in text boxes that is then stored in a table. It is possible for the user to enter data that may already be in the table, so what I want is a table in the user form to display the table data if 2 or more of the textboxes on the form...

Hello to all! This is my first post here and I'd just started learning VBA. I'm working on a project that in one point it needs a userform with the following function: I will have a combobox with 3-4 values, and textboxes for each month (so 12 textboxes). What I need now is that the values...

Hi, My userform has 36 textboxes that loads values from cells. Is there a code where if any of the textboxes is 0, it should be blank and not show 0. It’s because when half the textboxes are 0, it looks like a mine field etc. Thank you.

Hy, (It will be long... :) ) I have a sheet with some data in columns like this example, but the actual worksheet has 30 rows and 40 cols: <tbody> A B C D E F 15 4 14 18 85 27 2 47 57 30 67 29 </tbody> (yes, i wanted to populate the numbers from every second column) The...

Hi, I am looking for a script that will lookup data from my database based on the data entry in two textboxes. I will enter data into the two textboxes then when I click the lookup button, I want it scan through the column containing the data and see if it can find those data in the two...