Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data entry with userform questions
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
VBA userform questionS | Excel Discussion (Misc queries) | |||
newbie with userform questions | Excel Programming | |||
Identifying Bottom-most Entry (And Other Questions) | Excel Programming | |||
Creating a Data Entry Userform | Excel Programming |