textbox1

I'm trying to get TextBox1 in UserForm1 to auto populate with the next number in a sequence. The difficulty is that the number system is irregular. It follows this format: XXX-YYYY-ZZ , where XXX is a constant identifier of our organization, ZZ is the last two digits of the year, and YYYY is...

Hi can someone help me to my project It is possible to get the last 3 digit number using command button and textbox1 and display the data into other textbox. I wish someone can solve my problem.

Hello and thank you for any attention my post may receive. There are two fields on my userform which are the focus of this process - ComboBox1 and TextBox1. ComboBox1 contains Accountable Leader roles. The code is assigned to TextBox1 - upon exit of TextBox1 the code triggers and validates...

Hello, I have a userform with over 100 text boxes... Is there any way to change function of below code? Like from textbox1 to textbox100 all will be same format instead of typing one by one... TextBox1.Text = Format(TextBox1.Text, "###,##")

I have never used "Target" before. I have a list of name (a18:a150) and want to click on one and have the name inserted into textBox1 in userForm2. I can get the range set correctly and "userform2.show" brings up userform2 (which has my textbox1). I cannot figure out how to get the name from...

Greetings all, I have a userform that I use to input names on a sheet. When the userform opens, textbox1 will populate depending on if a certain cell contains a name based on this line. UserForm2.TextBox1.Value = Worksheets("list").Range("e" & res).Value This works fine. I recently added the...

Hi...I'm not really sure if this can be done using excel formulas or using VBA..here is what i want to accomplish. I have two Texbox in userform...Textbox1 and Textbox2. If I will input the value "120" in Textbox1 and "245" in Textbox2 i want the result to be arrange/distribute in this manner...

I hope this makes sense. I am want to be able to copy a formula to a cell, but I need it to use the next row number. See below: The Column won't change, but the row number will change. How can I copy this simple formula to use the active row this is copied too? Thanks, SB

hi. I need to populate my textbox based on criteria (from another textbox). below is my sample data (Sheet2) <tbody> A B C D E 1 133 ABC OCT-8-2018 12.50 EEE 2 254 HDS SEPT-1-2018 32.50 GGG 3 456 NJH OCT-10-2018 36.12 DDD 4 569 SDF AUG-21-2018 25.00 UUU 5 112 JRT JULY-6-2018 15.00...

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

Hi hope you can help me please, I have the following code below, where when command button is clicked on I want it to auto update textbox1 with the data it finds in sheet 5, Colum A and row 1, can you help me please? Private Sub CommandButton5_AfterUpdate() Dim Fnd As Range Set Fnd =...

Dear All, Could you please help me to create new Userform and including combobox which I can filter and select material name (material names need to be took from any excel sheet) and when I click ok then this need to be saved "account" sheet (each time need insert new row). Textbox1 will be...

I am trying to figure out the code for the Button (Save to Pdf) when activated will use the name from the TextBox1 as filename and save it to PDF, Can anyone help? TIA....... https://drive.google.com/file/d/1S0X9Ty9LIy4Slacuj5Fr_We-62Mv-FlZ/view?usp=sharing

Hello, I have a textbox (textbox1) that updates a value in another textbox (textbox2). I would like to make textbox2 update only when I'm completely done changing the value of textbox1. Can someone help me delay the change of textbox2, please?

This is weird: I have 4 command buttons (CommandButton1 thru CommandButton4) and 1 text box (TextBox1). I get a 424 Error whenever I try to set a TextBox1 property such as TextBox1.Left I ran a short sub to grab all the shape names in the active worksheet: For Each Sh In ActiveSheet.Shapes...

Hello, im not sure how to code this (obviously lol). i have a simple user form that has 1 combox that lists all items in column a. I have a text box that lists the text in column next to it (column b). what im not sure how to do is to let the user type in a new item into the combobox and text...

Hi I have the code below but i want to change cell A2 to a 'TextBox1' as now instead of using cells and vlookup i want to put this into a userform instead, so in textbox1 i will enter the data to search then in textbox3 and textbox4 it will display automatically the results, can you help please...

Hello Friends I have a user form with Textbox1 CommandButton1 CommandButton2 I want to type a name in textbox1 then with CommandButton1 I want to attach hyperlink with Textbox1 text and with CommandButton2 I want to add that text with hyperlink on next Blank Cell in sheet will some on help me??

I have a textbox (Textbox1) which I want to hit a command button (Update) and have it remove the last two characters in Textbox1. Is this possible? I have been trying to utilize: strRight = Right(str, 2) I don't know how to use that to remove those specific characters from the textbox...

Hi, I was wondering this was possible. I have a userform which enters the last number in the textbox1 from my worksheet. What I would like is if the operator hasn't changed the number in textbox1 and then clicks the send button a message box appears telling them exactly that. Basically I...