Hello,
Good day to you...
I am trying to create a Data Entry Userform...I am New with VBA excel.I have created One Spreadsheet .but need more code to complete the Userform .
Please find the attached file....
We are providing a Hand Held Device to the Department staffs. Following a Log sheet manually (as per
below snap shot)so it’s difficult to handle and calculate total time used the HH device.
There is a Number mentioned on each HH device .....And every Staff has an ID number
In my suggestion is staff Only enter their ID then the system need to ask one by one automatically that,
which section= Combo box type... then (which HH Number” = this should be textbox because all HH
Device Having a Bar code . we have a Hand scanner to scan this number ) after that press Enter Key...
the data ( date+Name+section+HH No +Out time ) to enter in spreadsheet Row.
Once taken HH Device they need to be returned the device... so we need to complete the Log
Row....when they returned (report), First they need to type or scan their ID to the particular
Textbox ( Name as Returned or any other Name ) then the existing non completed Data Row need
to Retrieve ,then need to scan the HH number ...>Remarks need to select then > click the save or
Submitted Button, the data should go to the same row to complete the Log.
(In time and used Time =automatically enter to the worksheet )
Thanks in advance for any help!!
Bookmarks