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