userform code for timestamp on w/sheet

  • Thread starter TUNGANA KURMA RAJU
  • Start date

T

TUNGANA KURMA RAJU

Hello Vba experts,
Through a userform I would like to add data to timesheet(w/sheet), my sheet
has four columns Viz. Col A-"Employee Id",Col b- "date',Col C-"In Time",and
Col C-"Out Time".My userform has a input Textbox ,2 Command Buttons "In Time"
,"Out Time".
whenever a user enters employee id and exists from input text box ,the code
should check whether "Intime" or 'Out time" of the employee is to be entered
for the current date/previous day.Accordingly "In time" Button or "Out
button" be activated.
It should update last row of my w/sheet and a message be displyed in
time/out time and date of the employee on userform before it closes.
 
Ad

Advertisements

D

Dave Peterson

Check your other post.
Hello Vba experts,
Through a userform I would like to add data to timesheet(w/sheet), my sheet
has four columns Viz. Col A-"Employee Id",Col b- "date',Col C-"In Time",and
Col C-"Out Time".My userform has a input Textbox ,2 Command Buttons "In Time"
,"Out Time".
whenever a user enters employee id and exists from input text box ,the code
should check whether "Intime" or 'Out time" of the employee is to be entered
for the current date/previous day.Accordingly "In time" Button or "Out
button" be activated.
It should update last row of my w/sheet and a message be displyed in
time/out time and date of the employee on userform before it closes.
 
Ad

Advertisements

T

TUNGANA KURMA RAJU

Dave Peterson ,can you help me with this post.I have reviewed the other post
,not tested,after testing I will reply if there is anything wrong.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top