-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
textbox.value
-
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...- Doflamingo
- Thread
- Replies: 3
- Forum: Excel Questions
-
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...- patsfan1
- Thread
- Replies: 8
- Forum: Excel Questions
-
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!- ajay_gajree
- Thread
- Replies: 2
- Forum: Excel Questions
-
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...- business_analyst
- Thread
- Replies: 2
- Forum: Excel Questions
-
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...- baxtercavendish
- Thread
- Replies: 14
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Copy dates from one sheet to another in range if date is old than 11 months
- Started by DanSMT
- Replies: 36
I am having an issue pulling dates from one workbook.sheet to another workbook.sheet. I've been working through the code. not sure if this is... -
Date and reference number being inserted into footer after the first page
- Started by dpaton05
- Replies: 37
How do I put things into the footer on all pages after the first using vba? -
Highlight Adjacent Cells in a grid
- Started by JLEMS
- Replies: 33
Hi. I am new here and I have been trying to figure out how to get a spreadsheet to do what I need it to, but have not found the exact way to get... -
Calculating lost hours per week
- Started by gd6noob
- Replies: 26
Hi there, I have a worksheet that calculates lost hours for employees. Basically it cells AE to CD are weeks 1 to 52 and it looks at the start... -
VBA Open .txt file with a string
- Started by ItalianPlatinum
- Replies: 25
I have a VBA code that works like a charm that displays a dialog box and allows a user to select a file. I am trying to enhance it to force the... -
Invalid qualifier
- Started by dpaton05
- Replies: 24
I have a procedure that moves some buttons. They need to be moved to just below the bottom of the last entry in column A. I get an error saying...