textbox1

hi, expert i need help the adjusted these codes i have userform contains textbox1,2,3 the textbox1 : Private Sub TextBox1_AfterUpdate() TextBox1.Value = Format(TextBox1.Value, "####.00") end sub and textbox2: Private Sub TextBox2_AfterUpdate() TextBox2.Value = Format(TextBox2.Value...

These are a few things I want to bypass. I am using textbox1 and textbox2 These are for textbox2: 1. The textbox should take only numbers and letters no other character accepted. 2. Letters should not start the entry. So A5 is not allowed 3. After a letter, no more input should be allowed...

hi, expert i would help finding code connect the data sheet with optionbutton , compobox and textbox in userform for explanation i have data in sheet1 in columns c,d are two prices price the column b is the brand and userform 2 optionbuttons and compobox1, textbox1 here when i choose the...

Hi hope you can help, I have a userform1 with multiple texboxes in and I want this to automatically load up with informaton from the 'Data' sheet into the textbox, I have done the code below but its not working, nothing appears in textbox1. for Example TextBox1 I want to look in a sheet...

Hello, I have a sheet "Clients" that contains all clients details as the table below and I have all these data as dynamic named range "Client_Details" "A2:D4" I have a userform with many text boxes and combo boxes, but what I need right now is: Once I choose a Client name in the combobox1...

I have an active x text box that will not increase in size for extra lines of text that are added. I want it to be a set length, 540 and to increase in size downwards when additional lines of text are added. This is the code that someone helped me with, can someone tell me what I need to...

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

Hi everyone, I have a userform that has a textbox1 initialize with today's date(mm/dd/yyyy) and a combobox3 initialize with today's date format(dd). I am using the combobox3 to write to specific rows of the spreadsheet, when they need to make a change to a specific day's data they just change...

RE: Multiple display of timed userforms ... Action1: it's 8:00 AM. Open a new Userform1(blank textbox1): Enter data: Userform.DTPicker1.value = Time 10:00 AM (display time) Userform1.Textbox1.value = Buy oranges close userform Action2: 5 minutes later: open a new Userform1(blank...

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

Hi, I have an Multi-Line ActiveX TextBox1 that has the below strings as separate lines: 'Cat' 'Dog' 'Snake' 'Bear' 'Dragon' I have TextBox1 linked to a single cell, so that it will output these lines to one cell. I'm trying to figure out a way (if indeed it's even possible) to output each...

Hi, I need a combobox_Change() code that will update my textbox1 that when I make ANY selection in my combobox, it will add "+1" to my textbox. Events - I select a combobox selection in cmb1 and in textbox1 it just says "1". I select another combobox selection in cmb2 and in textbox 1 it...

Hi, Is it possible to calculate averages on a userform with TextBoxes/Comboboxes? Example: Combobox1.additem = "50%" combobox2.additem = "100%" Maybe...? Lol Textbox1.value = combobox1.average + combobox2.average Visually it would say within Textbox1 75% So, before I hit submit on the...

With the code below, I am trying to highlight a default value of 000000 in a textbox (textbox1) in my userform. This will allow the user to overwrite the default entry without having to first select it. With TextBox1 'rental number 'cb_mri.Visible = False...

Hi there, I have a sheet as follows A B x www.google.com y www.yahoo.com z www.anything.com I created userform with (textBox1) & (commandbutton1) i need it to : when i insert a value in textbox1 (say x or y or z), and then clicking commandbutton1 it opens the link in B column...

I have a listbox containing a list of files in a folder. I also have a Textbox1. I need a code that as soon as I type in the textbox1, it filters the file names in the listbox.

Hey! I have a form that looks like this: TEXTBOX1 | TEXTBOX2 | TEXTBOX3 | TEXTBOX4 Each textbox is bound to a table column in a table called: Volume_tbl I want to store all inputs made by the user. But now i want to add calculations.... dont know how tho. I want to take TEXTBOX1 + TEXTBOX2...

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

Row 100 contains the Text "Comments". With the cursor always on row 26 of the active column, the following code is not working correctly Cells(74, ActiveCell.Column).End(xlDown).Offset(1, 0).Select ActiveCell.Value = TextBox1.Value It should put a new value from Textbox1 of Userform1 below...

Hi if selected the backcolor of Textbox1 which is &H0080C0FF& Can any one tell me its RGB Value Thanks NimishK