+ Reply to Thread
Results 1 to 1 of 1

Create a Data Entering and Updating Userform

  1. #1
    Registered User
    Join Date
    03-04-2014
    Location
    dubai
    MS-Off Ver
    Excel 2007
    Posts
    1

    Create a Data Entering and Updating Userform

    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!!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Userform (for Entering Data)
    By Faraei in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-22-2014, 10:48 AM
  2. [SOLVED] Refresh UserForm after entering data in another userform
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-30-2013, 10:34 AM
  3. Need help entering in data from userform
    By adamjohnson182 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2013, 08:15 PM
  4. Replies: 4
    Last Post: 11-28-2012, 06:09 PM
  5. Entering data from a Userform into a row
    By dougwild in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-18-2012, 10:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1