Auto fill specific cells from userform

**JamesT1** · 05-25-2009, 04:11 AM

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

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**royUK** · 05-25-2009, 05:09 AM

Why is it a problem? Simply add the information then sort by dates, you don't need to add rows either doing it this way

**royUK** · 05-25-2009, 06:42 AM

I've amended your code to add date & the userform. You should remember when naming controls to use a prefix that identifies the type of control - g cbo for ComboBox. This makes it easier to understand the code.

**JamesT1** · 05-25-2009, 02:14 PM

royUK

Thanks for the advice,,,

I was getting hung up and fixated on the code,,,,,, the master spread sheet takes up to 200 vehicles and as I plan on using this sheet for a few years I was thinking it would get rather crowded with numbers.

After reading your first reply I revisited it taking out most of the code and altering it so that only the current and last 3 weeks will show,,,, hiding the rest from view

now works the way I wanted it too

many thanks