.cellsirow

  1. S

    Find last available row in a range of cells

    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...
  2. A

    Trouble populating email from Userform

    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...
  3. L

    Completely stumped with number formatting

    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...
  4. B

    UserForm in excel - searching for duplicates

    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...
  5. W

    VBA code to find date in range and then post data in form to cells along row

    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...
  6. V

    Date format in Userform

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

    VBA Script Document.GetElementsByName issue

    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...
  8. P

    VBA Script to send form information to a new line in excel sheet on same drive

    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...
  9. R

    Problems with Adding a new line to a table

    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...
  10. D

    VBA code stopped working, can't figure out what went wrong

    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...
  11. J

    Userform to populate 2 sheets

    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, _...
  12. M

    Why has my code stopped working?

    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...
  13. M

    Form Creation and Programming

    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...
  14. L

    Worksheet MOD formula in VBA

    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()...

Some videos you may like

This Week's Hot Topics

Top