Results 1 to 1 of 1

want idea to how can make this in userform with database for lot of thousthand data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    want idea to how can make this in userform with database for lot of thousthand data

    Dear All VBA Expert
    please can see my attached file that i want to use Userform to enter this data

    for description for what i nature of this file
    i have number of operator as in my attached file (15 operator ) in Column E and each operator have Code which will be generated by Macro function for Random
    then this operator work to check batch of Number of spar part produced by machine (C3) and they working for 3 shift in each day C6 and start at day C4 and time C5 and product name C1 and batch C2
    each operator get 300 Spar part in each shift then after check they give number of accepted and rejected in column G and Column H
    all other calculated by formula as in my attached files
    then
    We sampling from each operator random sample and if we found some rejected part this operator will recheck this again as second check and soon
    i know may be my explanation not fully clear because really till now can't know how can i explain this
    hope someone can understand me even from the file attached
    have nice day for all
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Any idea to make this code work faster ( copy and paste data )
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2017, 03:33 AM
  2. Any idea to make code faster
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-28-2017, 07:46 PM
  3. [SOLVED] Anz idea how to make this code work in 2007
    By jj4jj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-27-2016, 06:33 AM
  4. Userform, Search, copy an paste data from a userform database to another sheet.
    By masro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-15-2015, 02:42 PM
  5. [SOLVED] Userform to get data from database
    By namialus in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-28-2015, 09:41 AM
  6. Userform - complex idea
    By jsneak in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 08-31-2013, 12:32 PM
  7. Can I make a database in Word with Excel Data
    By Myn777 in forum Excel General
    Replies: 5
    Last Post: 12-12-2005, 05:30 PM

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