Creating Data Entry MIS in Excel Sheet without an Userform

**sumit dey** · 04-11-2013, 03:33 AM

Hi Everyone,

I am current working in something which requires me and my team to record each of their Jobs with time taken to process the jobs. I don't want to use a Userform in this case. Instead i would like to use the excel itself to enter and record my data to the next sheet.

The data should come under the following headings on the NEXT SHEET:

Name (should be the default user's name)
Date: Today()
Fund: (Should have a list box so that one can choose the particular choice)
Type of Job: (This should also be a list box)
Activity: (This should also be a list box)
Mtrack#: (textbox allowing numbers only minimum 8 digits)
Job Level: (to include 3 items- process, Review & 2nd Level review)
Comments: (This should accepts any comments words, numbers, etc possible a Text Box)
Start Time: (To start when we click a button or Rectangle box)
End Time: (This should submit the data to the next sheet including start time and end time\total time taken).

I am very new to excel programming and VBA can anyone help me with this?

**arlu1201** · 04-11-2013, 04:16 AM

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**sumit dey** · 04-11-2013, 04:44 AM

Hi,

PFA; the sample file i was trying to create.

Also advice if you think there's a need to make changes to the sample/design of the sheet or you think will be better to add/modify/delete items etc on the sample file?

Thanks for a prompt reply