Results 1 to 5 of 5

Auto fill specific cells from userform

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    430

    Auto fill specific cells from userform

    Hi

    I am trying to create a spreadsheet to record vehicle mileage at the end of each week, however sometimes we cannot input the information until 2 or 3 weeks later. I am looking for a way to auto fill specific cells when the user inputs the information using a userform.

    On the attached spreadsheet:

    The first button input an 'Empty Row' ready for the new week and current mileage

    The second button opens the userform to select the vehicle, date and input the mileage

    I cannot figure out how to have the mileage inserted into the correct cell irrespective of when we insert the information.

    Any help to modify the code would be very much appreciated

    'find  first empty row in database
    iRow = ws.Cells(Rows.Count, 1) _
      .End(xlUp).Offset(1, 0).Row
    'copy the data to the database
    ws.Cells(iRow, 1).Value = Me.txtVRN.Value
    ws.Cells(iRow, 2).Value = Me.txtmileage.Value
    Attached Files Attached Files
    Last edited by JamesT1; 05-25-2009 at 02:14 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1