+ Reply to Thread
Results 1 to 1 of 1

Data Entry Form (similar to default Excel Data>Form)

  1. #1
    Registered User
    Join Date
    10-11-2005
    Posts
    1

    Data Entry Form (similar to default Excel Data>Form)

    I need to create a data entry form similar to the default one Excel provides via Data>Form and pass Range values into the data entry TextBox.

    I'm scaning 1-to-12 new employee# (barcode#) into 37 ranges (work_crews). The default Data>Form works, but is too cumbersome having to be reloaded each time of the 37 work_crew ranges change.

    I've created a form with CommandButtons that selects the crew_range as active, and I'd like to pass these ranges to a TextBox for data entry of the employee#s...

    Any help will be greatly appreciated...as I'm relatively new to VBA


    Thanks,
    tonydm

    Attached: My_DataForm.doc with CREW_1 & CREW_3 selected & Excel's default DataForm...with Crew_Ranges (1 & 3) chosen by a Select_Crew CommandButton.
    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)

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