M
mbernardi
I have a UserForm I am using to enter data for a monthly mileage
program. The form has 1 combobox and several textboxes. Data will
go into cells Sheet1!A8:F30. The combobox will be used to select one
of several routine routes I take. The textboxes are for Date,
OdometerStart, OdometerEnd, TotalMiles, Home/WorkMiles, and
BusinessMiles. The Combobox has a rowsource to Sheet2!a1:a8.
There are 3 things I need help with. First, I would like excel to
start putting in data at Sheet1!a8 the first time I open the template,
and then find the first empty row for each following entry. Second,
when I select a route from the combobox I would like the TotalMiles
and Home/WorkMiles to automatically be populated from Sheet2!b1:b8 and
Sheet2!c1:c8. Finally, I would like to have a command button on the
form so when I enter a new route with the new mileages they will be
saved to my Sheet2! A,b, and c. Any help would be appreciated. I
have been reading this group to help so far, but I can't find the
answers to these questions.
Thanks
Mark
program. The form has 1 combobox and several textboxes. Data will
go into cells Sheet1!A8:F30. The combobox will be used to select one
of several routine routes I take. The textboxes are for Date,
OdometerStart, OdometerEnd, TotalMiles, Home/WorkMiles, and
BusinessMiles. The Combobox has a rowsource to Sheet2!a1:a8.
There are 3 things I need help with. First, I would like excel to
start putting in data at Sheet1!a8 the first time I open the template,
and then find the first empty row for each following entry. Second,
when I select a route from the combobox I would like the TotalMiles
and Home/WorkMiles to automatically be populated from Sheet2!b1:b8 and
Sheet2!c1:c8. Finally, I would like to have a command button on the
form so when I enter a new route with the new mileages they will be
saved to my Sheet2! A,b, and c. Any help would be appreciated. I
have been reading this group to help so far, but I can't find the
answers to these questions.
Thanks
Mark