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

Watch MrExcel Video

This Week's Hot Topics

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
Top