data entry form

Hi Hope you can help me. I’m trying to create an excel data-entry form using VBA to capture data and -- when submitted -- paste the data onto a separate tab on the spreadsheet. This is what I have so far. This form will be used by my colleagues when they collect information from customers...

hi dear members good morning I have a data entry sheet. I i am using the data entry form which is designed by default in excel. you can see in the image But this form cannot be modified as per requirement. I want to design such a data entry form with some specific features. 1 I want that when I...

Hi, I am trying to create a 3 sheet document where 'Sheet 1' is a table where columns A to G are filled in then you would click a submit button (or something along those lines) and this would create a new row on 'Sheet 2' 'Sheet 2' is where Columns I-P will be filled in with information and...

unable to save the userform dat to worksheet Private Sub CmdBtnSUBMIT_Click() If VBA.IsNumeric(Me.TxtDISTCODE.Value) = False Then MsgBox "Please enter DIST CODE", vbCritical Else: Exit Sub End If If ComboBoxDEALER.Value = "" Then MsgBox "Please select Dealer", vbCritical Exit Sub End If If...

HI Excel Expert , Request your valuable help in solving the below error . PS: Am new to Excel VBA coding . I have got 3 Sheets in the attached workbook “Just combo V2” Download link : Just combo V2.xlsm Sheet 1 Sheet 2 =”School” in which Cell A1 : A14 Contains list of schools Sheet 3...

Hi all! I'm creating a data entry user form in VBA which allow the company to input/modify/remove staff members. Each staff member has a unique ID number. Can someone help me with a code that searches through the existing data (once they have left that textbox in the user form)to identify if...

I am trying to create a form that allows the user to input data into certain fields. Here is the code for the Submit or Okay Button. The data needs to go from the form to cells B15:I15 AND then once entered add another entry to the next row C16:I16 and etc. Please if anyone can help it would be...

Hello I'm not sure if this is the right place. I haven't used excel much since my school days, but would like to set up a simple database in Excel that I can use to keep track of jobs. And from this database I would like to be able to print out basic worksheets and quotes. I'd also possibly...

Hello - I am trying to find a solution similar to mail merge, but more streamlined and available immediately upon entering the data. I will have several staff members performing initial health screens. I would like to use a form for staff to enter required information. This information needs to...

Hi guys i downloaded a data entry example from http://www.contextures.com/exceldataentryupdateform.html#download and im currently trying to convert it to my own requirements im having trouble adding another table I cant seem to edit the range of the module (its probably something simple that ive...