textbox.value

  1. D

    VBA add new sheet to End of Workbook

    Hi all, I have a question Here is the code to add a new sheet having the name of a textbox.value from a userform Sheets.Add After:=Sheets(Sheets.Count) Sheets.Add.Name = textbox.value I would like to know why when the code is activated, the macro creates 2 sheets, the 1st rename with the...
  2. P

    If Textbox.value ="", Then Go to next line of code, if not do this

    Hello, I am attempting to run code in a user form that determines the difference between two dates (in two text boxes) and place that number in a third textbox. I am doing this for a large number of textboxes on the form. I want the code to check if either of the two date text boxes is blank...
  3. A

    Excel 2016: Excel VBA, Copy Userform Textbox.value to a new text file

    Hi All Can someone tell me how to copy a Userform Textbox.value to a new text file using VBA? I would like to save the new text file to the current directory Any pointers welcome!
  4. B

    Manipulating Text Box Values

    Hello All, I have created 14 Textboxes in a Userform. I would like to make it so that the numbers that a user enters into these text boxes must equal 100 (like 100%). However, the user is not required to fill out all 14 Textboxes. They may or may not fill out all Textboxes, but no matter...
  5. B

    strange run time error 13 - type mismatch - textbox.value issue

    Userform has textboxes for input / output, as well as combobox1 & 2 to load data into form and sheet in background. I have been trying to program it so that the user can simply change the text box prices and costs, and it updates on the fly. It works perfectly with only with one input textbox...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    • Replies: 44
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    • Replies: 35
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    • Replies: 28
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    • Replies: 24
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    • Replies: 23
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    • Replies: 23
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top