textbox2

hello i have sheet1 contains data from a2:d10 and userform contains textbox1,2,3,4 i would when i write in textbox2 it shows me the rest data in textbox1,3,4 the textbox1 connect column a textbox2 column b textbox3 column c textbox4 column d with considering column b...

Not sure if this is even possible, but I have a userform that has a width of 588 when fully viewed. What I'm wondering is when the user opens this I could have the width set at 150. And if in textbox2 they enter a 2 then the width of this frame will expand to 294. If the value entered in...

Inside column CA, I want to count if the input from a textbox exists with a different ID. Textbox1 is for the ID and Textbox2 is the item name. I am doing this verification during the update process. That's after I have clicked on a listbox to load my textboxes. I don't want same items...

Hi everyone! I have grouped OptionButton1 and OptionButton2//// and TextBox1 and TextBox2 in sheet 1. 1. I want to actively hide rows 10:15 along with TextBox1 and TextBox2 in Sheet 1 whenever OptionButton1 is selected. 2. Additionally I want to actively unhide rows 10:15 along with TextBox1...

Hello I am pretty new to VBA and I have a question In column A i have thousands of IDs, in column B their prices I have a userform where the user enters ID in textbox1 and in textbox2 the prices is retrieved. My question is if there is possible to enter multiple IDs in textbox1 and have...

Hello all, I was thinking is this possible to automatic generate a new number under a text box in macro when I open up the userform with my request: 1) starting with 1906-001, 1906-002, 1906-003... and so on 2) I wish the number showing in textbox2 and textbox2 is default on column C 3) after...

I have a Userform which is activated with the double clicking of a specific column. All this is working, but what I need is to have TextBox2 reference a cell off of another sheet. Not sure how to reference the other sheet. TextBox1 will show the current activecell contents on the activesheet...

Hi Good morning, please can you help me i have a macro to send an email and for the subject i want to add the text in the textbox2 into the subject heading i have done this in the code below but get an error please can you help? With NewMail .Subject = "Late Outage request - " &...

Hi good afternoon, i have the below code where i am copying and pasting data into another workbook, but there are several different workbooks which are all saved in the same folder with different names. So i have made a combobox1 with a list for example area1, area2, area3, then i have got a...

Hi, I want to check if the inputs from textbox2 and textbox5 already exist in my database. That's textbox2 entry is going to column C and textbox5 entry is pointing to column F. The data starts from row 2 . Row 1 is header. So say I have in textbox2, "Cat" and in textbox5, "green". And in...

I have a Userform (Userform1) where I have two Text Boxes (Textbox1 and Textbox2). When the user right clicks on a cell in Sheet1 I want to open Userform1 and populate Textbox1 with the data from the cell to the right of where they right clicked Target -1 Then I want to perform a lookup of that...

Hi guys I want to enter a PartID(text) in userform TextBox1 and have the userform display an alternative PartID in TextBox2 and description in TextBox3. Sheet1 has PartID1, PartID2, and Description in column A, B, and C respectively. I have this code below which appears to have worked for...

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 am trying to write a value of 0.00 to a cell, (Per Textbox2) but it keeps skipping over the value and not writing anything in the cell. I tried stopping the code and it shows up as .000 per the textbox2, but it jumps to the end of the statement. If I add a value of .001 it works, but 0...

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

I am completely new with Excel VBA and I have the query how the code: TextBox1 (50US$) If I put the value at TextBox2 (Rupee) result will go TextBox3 (Peso) automatically and vise versa (if I put a value at TextBox3 (Peso) result also at TextBox2 (Rupee) The bases will be from TextBox1 (USD) - -...

my userform contain 3 textbox TextBox1 value = 1 TextBox2 value = 5 TextBox3 value = 10000 sheet1 range("C2") = 120000 and range C3 formula is = C2*(1+6/100) now formula start from range C3 my problem is i need formula calucate till TextBox2 value ie. 5 menas formula calucate 5 cells C3:C7 if...

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?

Hi All, I need a script that will use the "ThisWorkbook.Path" and looks for a folder called "sFiles" in the workbook path and if not found, then create it and inside it, create other folders matching the names for all items in TextBox2. TextBox2 is populated by TextBox1 Thanks in advance Kelly

A user enters a cell address (eg: R23) into TextBox3 I would like a different TextBox ... TextBox2 ... to display the contents (a person's name) that would be found in column B of the same row of the cell address that had been entered into TextBox3... so in this example, TextBox2 should...