userform code

  1. P

    Adding data with a search userform & then populating another userform with values..

    Hi Team. Bit hard to describe here, but what I am doing is adding an address from a list onto a datasheet, using a userform,(oddly enough called "SearchUF"). So the code adds the new address in Col B using xlup and the remainder of that row is populated using a series of formulas. Which works...
  2. S

    Populating worksheet with a range of dates from a UserForm

    Greetings, I'm making my way up slowly but surely to get better at VBA coding but the road is still long thus I humbly request for any assistance from your side :pray: I actually have a worksheet as per below: <tbody> A B C D 1 Date Item X Item Y Item Z 2 3 4 5...
  3. M

    UserForm: Enter a number for the line to which the data goes

    I'm building a Rent Sheet. I'm using a UserForm to gather information (i.e. Lot#, Amount Paid, Check#, etc.) I would like to use the Lot # as a reference for my table. Example: If I enter Lot# 32 and click 'Submit', then the information starts at cell N34 (The starting cell of information for...
  4. E

    Workbook Visibility

    Hello all: I am creating a VBA workbook with UserForm to allow users to input data. I do not want the workbook to be visible to the user and have used "application visible=false" code. Everything appears to be working just as I want, however, I do not want to add a button/code the userform to...
  5. J

    Userform to seperate workbook

    Hi there, I've currently got two spreadsheets; 1) AOK Form (v2) - [This spreadsheet will be stored locally for over 100 users individually] This is where the form is located and it serves no other purpose than opening the form (there is a hidden sheet for lookup lists for combo boxes) 2)...
  6. M

    Populate listbox based on file name

    Hi Guys I am looking to populate 2 different listboxes but the files i wish to fill into the listbox are in the same folder. Currently i can get the code to fill listbox1 with all files but 1, which is put in the second listbox... I have been looking at a lot of threads, but i can't seem to...
  7. N

    Formatting numbers in a userform textbox

    I have the following code behind a textbox. I expect it to complain if the number enter is greater than 999.99, yet I can add 345566 and it gets accepted. What am I missing? Private Sub EntryBox12_AfterUpdate() 'Start Mile Marker If EntryBox12.value <> "" Then With EntryBox12 If...
  8. D

    Error handling in Userform

    Hello all. I created a payroll system in Excel and use a userform to enter employee data. See image below Named controls in order shown: Reg1 (DTPicker) TextBox1 (TextBox) Reg2 (ComboBox) Reg3 (TextBox) Reg4 (TextBox) Reg5 (TextBox) Reg6 (TextBox) When I click on the 'Add To Sheet' button...
  9. D

    userform to show based on cell value

    Hi All, I am trying to have a userform show if a cell value is selected as yes from it's drop down list. any help please. Below is the code I am using in the userform code coding sheet. Code: Private Sub UserForm_activiate() If Sheets("HCR").Range("C13").Text = "Yes" Then UserForm1.Show...
  10. S

    View/(Navigte to) the code module of a command button of a specific userform, using vba

    I currently landed up with a requirement, which is , to jump/navigate to the code module view of a command button of a specific userform. While it is easy to view the code window of the sub modules, using the Application.goto, it does not appear to be so , for the userform code window...
  11. T

    Updating database using userform dependent combobox selection (VBA)

    Hi all, I am new to post on this forum, but I have referred to this site on various occasions. Am also a VBA illiterate but I have some how made my Userform work. So here's my question. How can I update the database using the form which has dependent combo box selection? - I have created...
  12. K

    Need Vba querry for user form

    Dear Experts, I have an excel sheet data and i want add remarks against emplyee code in remarks column. Data is as per below details. Column A - Emp_code (Already filled) Column B - Emp_Name (Already filled) Column C - Remarks (Need to fill by user form) Kindly help me out and give me user...
  13. S

    Unable to Get VLookup Property for worksheet function class

    Hi All, I am getting "Unable to VLookup property of the Worksheets Function Class" Erro for the below code. Kindly assist I am using this code in a userform Private Sub ListBox1_Click() Dim l As Integer Dim f As Integer EST.TextBox6 = EST.ListBox1 l = Len(EST.TextBox6) f =...
  14. C

    Creating Multi Sheet User Form For Data Entry

    I am currently in the process of self teaching myself how to create a multi-tab user form to help with data entry in a multi-sheet work book. I have created the user form but am struggling with the code portion of things. I have created the simple code for the cancel button to unload, and...
  15. K

    Need a way to sort through already entered data via my userform.

    So I have a userform that populates a table, but I would really like two things added to my userform. First, I'd like it to be able to move between the entries via "prev" and "next" buttons. Then I'd like a way to open a specific entry of data. Anyone have suggestions or ideas of how to go...
  16. M

    Open 1 of 2 User forms dependent on Text input

    Hi I am trying to use just a scanner to operate a in out booking system so there is no need for keyboard or mouse skills by the users, I will simply provide a barcode for in and another for Out. I have 3 user forms 1 for booking in, 1 for booking out and a 3rd which I would like to use to open...
  17. S

    How to update only one Item in a list box?

    Hello everyone, I have a list box in which you can select multiple items. When you click modify, it will analyze which items are selected and go through all of them. That means it will first display the first Item with the Item ID and other information from the same line. Then I have the...
  18. Z

    Getting Run Time Error in Excel VBA Vlookup Userform

    Hello, I have the following code producing a run time error. It actually works and and gives me the proper output but it also gives me a run time error '13' for some reason. The purpose of this code is when a user chooses a Family Name from a combo box, a field called txtFamilyID is populated...
  19. C

    Allow multiple entries using same userform in excel 2013

    Dear Experts, Thanks for all your suggestions and inputs you have provided me for different queries I have posted on this forum. Request your help again for an enhancement feature, to include in my existing user form. I have attached screen shot of user form, which is to input data for service...
  20. C

    Detect Duplicate Entry as soon as its typed into the Userform

    Dear All, I have developed a user form with multiple text boxes and combo boxes. Request your assistance in writing the VBA code, which detects and pops message of DUPLICATE ENTRY, as soon as something (say ID number) is typed into the first text box or when tab is pressed to move to the next...

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