I am a macros super rookie. I want a code that enter the time just hours and minutes I want when I click the start button it enters in B3 and moves to next cell below every time I start button, basically same function when i hit stop button. finally if its possible i want it not to be possible to hit start if stop button has not been hit.. i will attach copy of sheet. sorry about no code tabs but I don't know what they are.
Hi superchew,
is that what you need? Picking Log excell spread sheet-8311.xlsm
Regards
Please use [CODE]-TAGS
When your problem is solved mark the thread SOLVED
If an answer has helped you please clickto give reputation
Read the FORUM RULES
This works amazingly, now is there and easy way to copy the code for the other five lines? I don't see a cell reference to change.. sorry I am very new to this .
Hi,
you can either create 2 buttons for each "line" and change the parameter given to "WriteTime" accordingly, e.g.
for the start button fo line 2
Please Login or Register to view this content.
or prompt use only 2 buttons for the entire sheet and prompt the user for a line to enter.
What do you prefer?
Picking Log excell spread sheet-8311.xlsmPreference would be to have two buttons for each line... this would dummy proof my process. being a newbie I tried to find the range so i could copy, paste and just change the range, but sadly I still am learning to read all this. also wondering I have inserted a drop down box of names in A2 as well as all corresponding lines is it possible that when I hit start and time is generated that the cell directly to the left can be equal to A2. sorry for tough questions trying to learn this as fast as possible.
Last edited by superchew; 04-20-2013 at 10:38 AM.
Hi,
try this: Picking Log excell spread sheet-8311.xlsm
Regards
you are my hero right now.. final question how do i get that drop down in the other five lines.
basicallly drop down in each line because I have a different person working each line.
Okay so I had to add some lines and change the form to be more funtional ansd i can't seem to figure out how to get the drop down box to work witht the names for each line. also when I enter data in line six it goes to line 3 if you can help me fix these issues i will not bother you again. thanks for all your help. Test 6.xlsm
Hi,
do you want to use one combobox for more than one line?
You can adapt the list of a combobox by right-click -> properties and change "ListFillRange"-property. This can be as in the example on another sheet, this sheet can be hidden if you like.
If you change the number of rows per line you will have to adapt this in the code atPlease note: Each button must be located in the column where the time has to be written into.Please Login or Register to view this content.
Do not change the order of the columns "", "" and "" otherwise you'll have to adapt the code inandPlease Login or Register to view this content.Test 6.xlsmPlease Login or Register to view this content.
Regards
I have the buttons in the line, but when i hit start for line six it enters it into three... also I want a one combo box for each line. I have copied them in design mode, but can't get them funtional.. i will try and figure out the start stop buttons in line six Test 6.xlsm
Hi,
please download the updated workbook from Post#10 (http://www.excelforum.com/excel-prog...=1#post3206723) and refer to that
Regards
Hi,
Will do when i get back in tonight.. after my last message I did atleast figure out how to enable the copied combo boxes, but could get it to change properties from combo 1 to combo2 everytime i tried it would reset when i closed the box. and still too stupid to figure out how to make the extra cells for start stop to work. i will check out your download an see if i can get it..
Thanks again for all your help
Last edited by superchew; 04-21-2013 at 11:09 AM.
Re: Start stop time in excel
thanks for all the help learned some good stuff.
I back needing some more help. I have attached my form. currently i have it that it calculates time by subtracting NOW() from the first start time minus break time. this allows all lines to be updated any time any one hits start or stop. what i need to do now is add a complete button on each line that will stop that line from updating.
Test 6.xlsm
can anyone help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks