Macro to input data from the data input box.

**jhc8255** · 10-12-2010, 10:30 PM

I have been trying to get this simple input box work on my own and its getting horribly harder as I try to get more complicated function out of it. The attached file shows what I have done so far. The "main" worksheet has an "add" box when click upon displays user input box that I have already made. When the input box pops up, there are several boxes and will input data as accordingly. First the user selects Grade and that grade will go to one of the corresponding sheets and then it will copy the data that the user has input and paste it under the corresponding column. The date added will be today's date and time (I was wondering if I can display today's date on the input box). Lastly, when the user inputs data, it is supposed to show the recent addition for each of the grade in the "main worksheet." I am a beginner when it comes to vba and I have searched and copied some relevant code which is still in the workbook(most of them do not work). Would anyone be kind to help me out of this situation? Thanks.

Regards,
james

**rylo** · 10-13-2010, 01:19 AM

Hi

Is this what you are trying to do?

rylo

**jhc8255** · 10-13-2010, 05:14 AM

rylo,

your code works like a charm. one thing though... on the line that reads

Please Login or Register  to view this content.

the function "datevalue", as far as I understand, will drop the time no matter what. The text that will go into the box will include the time and it is critical that I have it in place.
For example... I will copy the following into the text box... 09-Jul-2010 07:03 and I want the end result to be formatted: "yyyy-mm-dd hh:mm" Would you please take a look to see if you can change code so that it will display the time as well?

Thanks again!

Please Login or Register  to view this content.

Regards,
james

**rylo** · 10-13-2010, 06:18 PM

Hi

Try

Please Login or Register  to view this content.

As the items on Main go to a fixed place, you could format those cells permanently. You really only need the formatting to go on the inserted entry.

rylo