1. Y

    ComboBox and Date

    I wondering how can i formulate this textbox status to display textboxStatus to blank when combo box is closed and when combobox1 is in "Open" then TextBoxDate.Value - DateNow. if ComboBox1 = "Open" then TextBoxStatus = txtBoxDate.Value - DateNow Else if ComboBox1 = "Closed" then...
  2. M

    Userform textbox validation - private sub doesn't fire on tab exit

    Hello, I have a problem that probably won't matter at all but it is bothering me and I'm hoping someone can help. I"m a novice at VBA, but understand enough to adapt what I find and make it work for me, mostly...so I'm thankful for any help I get both with my VBA education and the...
  3. J

    ActiveX Input Format as currency with 2dp

    Hi All, I have been trawling the web and Mr Excel for an answer, but everything I have tried doesn't work. I am creating a userform that users need to be able to add in monetary values. Below is how I have the textbox set up at the moment, but it's not doing what I want: Private Sub...
  4. A

    Change Event for Multiple Check Boxes

    I have 25 text boxes named in the following manner on a UserForm Name: id_[X]_box 1<= x <= 25 I am trying to write a program which can register a change event for all 25 boxes and populate the corresponding [DESCRIPTION] Labels. Naming scheme for Description Labels Name: desc_[X]_label 1 <= X...
  5. S

    Textbox value change to Red if greater than 0

    Hi, I was sure that the following code below changes to Red if my Cell from E34 ( 1 ) and Cell (Q34) is ( 0 ) then please change my Textbox to "RED". Can someone check please - cause it aint working. Private Sub Textbox32_Change() If Sheet5.Range("E34").Value > Sheet5.Range("Q34").Value Then...
  6. P

    Some Users get VBA error 91 after call Userform with TextBox related to sheet

    Hi, I have this problem with code on some PCs (Error 91). Code is used to give user splash screen after start of workbook - where is classical EULA conditions located with button Accept and Decline. I have problems to call Sheet named EULA, which have the text for the Userform TextBox. Where I...
  7. F

    checkbox with condition on textbox

    hi, i want to make a command button which calculated a specific formula the thing i want to do is to grab the data from a textbox and multiplied with the costo of each type, but the textbox only appears if the checkbox is in its value true, for example (it is in spanish): the checkbox is not...
  8. F

    Function count if for text in textboxes VBA Excel

    Hi, I am doing a userform where I have 8 textboxs named ddc, example: ddc1, ddc1...ddcn. then I have another textbox name quantcoup, that is the textbox I want to receive the count if of everyone of the ddcs that have text in it throughout a command button. Also, I want that the count if detect...
  9. J

    Refresh spreadsheet when listbox updated

    Hi, I need help writing a vba code which had 7 textboxes and an update button to update the listbox then spreadsheet updated via the listbox. base on the colunm selected from the listbox, it populates through the textboxes. when selected column from listbox is selected, update is made via the...
  10. K

    Strike full line of selected text in form control textbox

    Hey, I am having trouble with my textbox 'correction' macro. What I want it to do is have the user select a line in a form control textbox. Then it should select the whole line and strike through it. The code I use to add lines to the textbox is as followed...
  11. Y

    VBA INDEX MATCH Application to display value in Textbox

    I am trying to use Index Match to replace Vlookup Function so my textbox displays date format. If I use Vlookup my textbox shows numbers. I tried the below code but it is not displaying the value in the textbox once I run the code. Can I please have your help to make the code work? Dim TBL As...
  12. W

    Saving data from textbox to specific folder without dialog as .txt

    Hi. I am trying to save information within a textbox, to a .txt file, to a spesific folder, without using dialog (this button shall basicly autosave the information within the textbox to a folder, with only saying something like "Submitted" when its done) I have only used...
  13. J

    Userform, textbox copy to sheet

    Private Sub ToggleButton2_Click() Me.TextBox1.Copy Sheets("Data Sheet").Range("L" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues Struggling to achieve a simple copy to the next available row in column L from a textbox in a userform. It is failing on line 2. Any...
  14. B

    Userform | Evoke Textbox change event when radio button is changed

    I have three radio buttons that the user can select Uppercase Lowercase Propercase When the form initializes the Uppercase radio button is set to true if the user selects one of the radio buttons I want the text already keyed into a textbox to update to the choosen radio button I have...
  15. S

    Referencing class variable(s) from another class

    I have two simple classes shown below for several userform textbox and spin button controls. Userform_Initiliaze event basically adds any such controls to relevant collections to manipulate later using events. What I want to achieve is to pass text from textbox class (clsTextBox) to spin button...
  16. S

    Copying data between two different workbooks

    hello, I'm trying to copy the text box inside my page. The code I used didn't work can you help me Thank you name of the textbox is "oyku" Sub oyku() ' ' Windows("1.xlsm").Activate Sheets("Kimlik").Select Sheets("Kimlik").oyku.Copy Windows("2.xlsm").Activate...
  17. T

    "Contains" filter on number and text column

    Hi, I've got a column that I want to filter using "contains" filter in my vba code. Most of the column data is a 3 digit number - e.g. "842" But some have more digits/letters - e.g. "84203-A" Filter input is from a textbox in a userform. Is there any way I can use an autofilter so that if...
  18. A

    Carriage (Enter) instead of word wrap

    Can someone as assist with a code that will enter a carriage (Enter) whenever the multi-line textbox wraps the string to the next line. I know the multi-line textbox will do this for me, but I need this to enter it a cell to indicate to separate line. Thanks for you
  19. S

    Populate rest of Userform based on two ComoboBox Values

    Hey all, I am trying to quickly get order data from a single sheet of over 3000 entries using a UserForm to make it as simple as possible for staff. So far i've made a userform that i want to use containing a number of text boxes: "Cust ID", "Order #", "Item", "Part No", "Date Ordered"...
  20. C

    Populating a TextBox with a % Value taken from worksheet cells

    Hi there, I have a calculation taking place on a work sheet - a calculation to work out a percentage. =IFERROR(SUM(D6/D5),0) In this example I'm using Loan (£100,000) / Property Value (£200,000) = 0.5 (formatted to %) = 50% All I want to do it have my user form pull through the value of...

Some videos you may like

This Week's Hot Topics