.cellsirow

Hello, I am looking to make a code work in the way that it finds the last available empty row in columns A to L since M will have data pull with a formula. But I am not sure how to or where to add the range to make it work. Can I please ave your help? Dim iRow As Long Dim ws As Worksheet Set...

morning guys got myself a little stuck with this so I have created a userform that once populated with the relevant info fills a log on sheet1, I then want It to email the data that was entered to myself. where am I going wrong, I have bitten off more than I am capable of Private Sub...

Long time no see. I am having a nightmare trying to get data from a textbox to a cell in a number format. I have tried just about every tip and trick on the net and either my vba is wrong or I'm being a bit dense. With Worksheets(SheetName) .Cells(iRow, 1).Value = Me.txtWhen.Value...

Hi, I require help as I have a tried a number of options found in the forum but none seem to work... This is what I need to happen - the person completes the User Form. Once they submit, I require a search to happen to see if it is a duplicate entry (First name, Last name and user ID already...

Hi all, VBA noob here, so please bear with me. I've built a userform to allow me to enter data and then put it into a set of cells from row D onwards based on the date entered by finding it in a range (C8:C267) in the sheet to be filled. My code is pasting the data, but is not placing it in...

Hi All Just trying to teach myself a little VBA. I have created a user form and when the date is entered in dd/mm/yyyy format it unloads to the database as mm/dd/yyyy I have searched around and tried differing code but to no use any help would be much appreciated I have pasted my attempt below...

Hi All, I am trying to approach this from a different angle, the below code is a watered down version of what i ask trying to create, where a form is used by a single use on a windows machine running IE where the output of the form sends the data to a single excel sheet. The text box works fine...

Morning All, What i am trying to do is create a single web page that has text fields and radio buttons to allow a user to input data using a touch screen prior to hitting a submit button and for that data to be sent to a single excel file. I found the following code during my google research on...

I have set up some command buttons that open user-forms for my end users to enter data into in order to update tabs in the workbook. I have set up three tables, one in each of the three tabs. The problem is, in two of the three tables a new line is not being created in the table. It just...

I have a userform that I've been developing for a few weeks now. My Private Sub cmdADD_Click() button will not operate anymore and debugger window appears when clicked. When I try to debug it goes to this line of code: .Cells(iRow, 1).Value = Me.txtDate.Value. Button was working great, but then...

So I have this code to enter data from a userform. Private Sub cmdAdd_Click()Dim iRow As Long Dim ws As Worksheet, ws2 As Worksheet Dim CopyToSheet As String Set ws = Worksheets("Ingredients") 'find first empty row in database iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _...

All The intent of this code is to find the last filled cell in column 16 and move onto the next column, gather all the information in that row from columns 1-15 and input them in a form. It was working fine yesterday, now all of the sudden it stopped working. It always goes back to the first...

All I was able to find a good functional VBA code to place form data into a database(almost completed just need to add defects). See below. What I want to be able to do is instead of having a column for each of my defect families and types, I want a way to have the program review what is...

I hope someone can help me with this as it's driving me nuts. iRow 3 and 4 are time values that may span more than 1 day. For some reason the line of code in red, puts FALSE in the worksheet cell. I have posted the whole procedure so you can see what is going on. Private Sub btnUpdate_Click()...