textbox1

  1. A

    sum format number textbox in userform

    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...
  2. kelly mort

    Check if a textbox contains more than one letter

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

    Code link optionbutton ,compobox with textbox and cells in sheet

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

    How to autopopulate a textbox linked to a cell

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

    linking combobox value with VLOOKUP to a textbox in userform

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

    Active x textbox not increasing in size with additional lines of text

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

    Hide Unhide rows and active x controls based on option buttom

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

    Populate a text box based on the value of a combobox

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

    RE: Multiple display of timed userforms ...

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

    Application.Match

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

    Is it possible to extract strings from a Multi-Line TextBox?

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

    Count string of text in combobox

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

    Is it possible to run averages on a userform?

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

    Textbox Default Value Not displaying During Userform Initialization; Selection Highlighting

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

    Vlookup using textbox and commandbutton

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

    Filter the array in listbox

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

    How to calculate textbox values and store all data in my table?

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

    workbooks open with range

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

    Getting .End(xlDown).Offset(1, 0).Select to work correctly

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

    RGB Value of Textbox1.BackColor which is equivalent to &H0080C0FF&

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top