userform textbox

  1. N

    Data entered into userform is not calculating Type mismatch?

    Hello wonderful excel people, I am having an issue that has me stumped that I was hoping to get some help on, please. I have a userfrom with a few text boxes for text and services/products to be written and then another 12 textboxes (tb_sprice1 - tb_sprice12), where I'm able to type prices...
  2. F

    Change events - Userform Textbox

    Is there a change event for userform textboxes when leaving a textbox, without making a change. So you select a textbox and then leave it (selecting another textbox), without making any changes or pressing Return. It's not the following: - Enter - AfterUpdate
  3. D

    Userform TextBox not passing value to worksheet when "Add to Sheet" button is selected. Other values are passed

    Hello Everyone. I'm relatively new to Excel VBA and above average with Excel formulas. A lot of my assistance came from finding answers to my questions from this forum but I've exhausted resources on the web looking for an answer to this issue but to no avail I'm out of resources so I came to...
  4. R

    Restricting TextBox Numeric Range

    Hi Everyone, I have TextBox1 in a userform. When somebody opens up the userform the textbox is prepopulated with a number already in it (.31), however I did leave the option for the user to change this number if needed. The reason why there's a decimal because when the number is submitted on...
  5. W

    Populate userform textbox with combobox selection (multiple occurrences)

    Thanks in advance, What I am trying to do is use a userform combobox to make a selection and populate multiple textboxes within that userform. The sheet that the values from the combobox are found in Column A. The values occur more than once. The values that are needed to populate the text...
  6. L

    Summing up numbers from a single textbox on a userform

    Hello all, I've been trying to figure this one out on my own, but can't seem to. So I turn to you all! Here's what I'd like to do: On a userform, I'd have two textboxes: One for a person's name, and one for the amounts of refunds they may have processed. i.e., Joe has turned in handwritten...
  7. K

    Code to loop through textboxes on a userform without specifying the name

    I have several userforms and each one has several textboxes for which some are named textbox and others are named "HC", "CC" etc. with numbers ranging from 1 to 400. (I should have set up my forms in a more consistent way but we're past that now I think). Is there code that would loop through...
  8. K

    vba userform textbox formatting

    How can I maintain decimals in a textbox but only display in this format: "#,###"? For example, the user inputs a cost estimate of 1,300 for the year so the Jan - Dec text-boxes are populated with 108 but the real number is 108.3333 but when I have the textbox save the data back in the...
  9. C

    Adding number of days to date in userform textbox

    Hello, I have a really simple problem that I need help with regarding dates on my userform. TextBox1 = a date (which I need in mm/dd/yyyy format) TextBox2 = a number (30 as an example - this is number of days) Textbox3 = the date in Textbox1 + the number in Textbox2 So textbox3 will have a...
  10. B

    Is there a way to assign all digits of a number entered in a userform textbox to a variable?

    I hope the title is not confusing. Well, let me explain. I have a userform with a textbox. I assign the user-entered value to a variable like this: Dim balance as Long balance = UserForm1.TextBox1.Value Now if user enters 1234 in the textbox, first 1 gets stored in 'balance' then 2, then 3...
  11. K

    Hide Frame in Userform and SetFocus to ComboBox

    I am working on a Userform where the user can select a project name from a ComboBox (which is inside a frame) and if the selected project is one named "New Project" then the Userform unhides a second frame that has a TextBox where the user can enter in the name of a new project. (These two...
  12. J

    Userform textbox to multiple rows

    Hi, This is my first time posting on here. I might be in over my head but I am sure there is someone out there who knows the answer. I have a userform with a textbox in it. I have the textbox set to multi-line. Whenever I run the macro I've created It will take the input, find the spaces...
  13. B

    Userform Data Validation

    I need the text box in the userform to accept only alphabet letters. This is the code I have so far but it only accepts 2 letters. Also, the message box telling the user to only enter letters pops up when the userform is initialized and after the text is inputted. How do I fix this? Private Sub...
  14. R

    macro to move cursor to specific userform textbox

    I'm trying to create a keyboard shortcut which will run a macro which will move the cursor to a specific textbox in a userform. This is the macro I have to move the cursor: Private Sub Cursor_to_textbox1() textbox1.SetFocus End Sub Because the above macro is a 'Private Sub' macro, I cannot...
  15. R

    Show Activecell.value when in vbmodeless?

    I have a userform which contains a text box which is used for data entry purposes. The form is always open (i.e. running in vbmodeless) and I am trying to get the text box to display the 'active cell value' (using Text = ActiveCell.Value), However, whenever I move the cursor to a new cell, the...
  16. M

    dynamic text box location on userform

    hi all, I have a userform that has 19 textboxes on it. I would like to enlarge the textbox when entered so as to give enough room to type a multi line answer as needed. My question is.... is there a way to reposition the text boxes below the active text box dynamically, say based on the top or...
  17. G

    Saving textbox data from a userform to Sheet2 cells...

    :confused::confused::confused: **Note: I do not have the ability to upload attachments under my profile for some reason or I would. Is there a way to be able to attach documents?? Hello! I have a macro that formats "Sheet2" from data in Sheet1 and then launches a user form (UserForm1). From...
  18. F

    Keep focus in userform textbox when press enter

    Hello I've got a userform with a textbox (TextBox1) in Excel 2003. When the user types into TextBox1 and presses enter I want it to act as it would e.g. in a Word document where the cursor moves to the next row down. I know that if you press shift+enter the cursor moves down but for the...
  19. K

    Textbox input limitations on userform

    Hi, I have a userform with 2 text boxes for users to complete. one should contain a numerical value, the other should contain the user's initials. Is there a way to limit the entry to the text boxes so that it will only accept numbers for the numerical entry and only accept letters for the entry...

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