Results 1 to 1 of 1

Macro Problem with VBA need Help (copy past cells with macro and message box)

Threaded View

Nissort Macro Problem with VBA need... 03-25-2013, 12:17 PM
  1. #1
    Registered User
    Join Date
    01-29-2012
    Location
    Netherland
    MS-Off Ver
    2010
    Posts
    9

    Macro Problem with VBA need Help (copy past cells with macro and message box)

    Hello,

    Antony helped me with this macro in first place, think this was 8-10 month ago.
    all worked fine.

    but now we need to change something and i can't figrue out how.

    is there anyone up to and can have a look and help me please?

    What i want to get running is if i push on the button Pick is that the macro checks if in field F7 a "batch" is selected if not messagebox should come up please select a batch.
    if field H7 (picker) is not filled in with a name then messagebox comes up please fill in a picker name
    if field J7 (Time) is not filled in a messagebox comes up please fill in the pick start time.

    if all fields in line 7 (F7, H7, and J7) are filled in the macro should search for all fields in the sheet with a batch number in column F (start search from row12) and replace the batch numbers (for example B1 with the name in field H7 and the time in filed J7) the name should go in column F start row 12 (Picker) and the time in cloumn G (start) start row 12 for that batch number.

    can someone help me please?



    PPP report empty.xlsm


    thank you in advance


    Arthur
    Last edited by Nissort; 03-25-2013 at 01:43 PM.

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