Log User Input In Successive Rows

Hello,

I am new to the Forums and need help with an application I would like to create.

I am trying to build a user-friendly Excel database that takes the user's input from various cells and logs that data input by the user in successive rows to the side. Please see the screenshots of my current spreadsheet below:

Compressor Database.jpg

From the screenshot above, I would like for the user to input their data for the Date of Last Inspection, Current Hours, and check the boxes for any services they performed in the orange/pink "Input" box on the left. Currently I have the spreadsheet set up so that the orange/pink "input" areas recognize data put in to the yellow "Data Log" cells to the right. I am trying to get the yellow "Data Log" cell area to store the Date and Hours data put in by the user in successive rows like a database, but I am not sure how to do this. I was thinking of putting a button in the says "Log Data" which would, when clicked, store the data in the "Data Log" cells. I am unsure if I need to use a Macro or whether Excel has a simple, built-in function that can be used. Eventually I have plans for the "Date of Last _______ Change" Gray boxes, but would like to take this one step at a time.

I am not well versed in VBA and Excel Macros, and I am currently using Microsoft Excel 2007 (yes, I know it is old). I do have C# and Matlab coding experience, however I would like to do this in Excel to make it easier for the User as it is a well known program.

Thank you for any help or advice you can provide.

Vergewaltiger

Hi

It's not always so easy to get the ranges correct with just a picture, but I think you idea about a button sounds good, take a look at this code:

Please Login or Register  to view this content.

Picture:

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi

There were som merged cells in your sheet, but try this code:

Please Login or Register  to view this content.

Perimidt,

Thank you for your advice, however I'm not sure where I should use the code you provided. Is that for the button I would put in for the user to log their data? I apologize for the stupid questions, I am not very experienced with Excel Macros or VBA. When I go to place a button and enter the code you provided, the first line does not match up with your code. This is what appears when I attempt to edit the button's code:

Please Login or Register  to view this content.

I'm not sure if I should try to record the Macro or input the code some other way.

Hi

Try to paste this after Sub Button14_Click()

Please Login or Register  to view this content.

Hi

I think there is some junk in those cells, just right click them and clear contents.

Hi

I think you have to use the check-box from the ActiveX Controls, then you will have access to the click event and can use the following code for Oil Change:

Please Login or Register  to view this content.

Check the attached workbook as well.
Log User Input In Successive Rows.xlsm

Hi

This is sort of tricky because you have to reference the sheet the ActiveX Control is on.
My suggestion is to add it to the buttons click event, like this:

Please Login or Register  to view this content.

Just be aware that you cannot change the sheet-name.

I've run into a problem when trying to create another sheet for a different compressor. Essentially I would like the two sheets to do the same exact thing and look identical besides the compressor name, brand, and location. I created a new button and 3 new check boxes for the second sheet but the rest of the sheet is just copied and pasted from the original sheet.

When I went to write the macro code for the button, I simply duplicated the existing code from the original button. When I enter data onto the second sheet and click the new "Log Data" button, I get a message about a run-time error in the code for the new button. I posted the run-time error below as well as an example of the workbook. Ideally I would like to have up to 14 different compressors, each with their own sheet, in the same workbook, that all do the same thing as the original compressor sheet.

The message pops up and says:
Run-Time Error '1004':
Method "Range" of object "_Global" failed

When I hit "Debug" the following line of code is highlighted and I'm not sure what I need to do to fix it:

Please Login or Register  to view this content.

I believe it has something to do with the Range("J1048576") being sepcific to the sheet of the original button.