Results 1 to 11 of 11

NEED HELP! Code that checks all data has been entered before my VBA Macro Runs!

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2014
    Location
    London
    MS-Off Ver
    Windows Excel 2010
    Posts
    79

    NEED HELP! Code that checks all data has been entered before my VBA Macro Runs!

    Hi guys,

    I have the following macro which allows you to enter a row of data (Only one row will be visible), then you press a command button and the row of data is inputted into another work sheet.

    * I would like a way of ensuring that Excel checks the whole row of data has been filled out before allowing itself to run the following macro (which copies and paste all the data across to the other worksheet).

    Here is the code I have so far. (Just to advise this macro starts on the "AddRecord" sheet.

    Please someone out there if you can help me I would be forever grateful!!! :D
    
    Sub addtoInboundWorkstack()
    '
    ' addtoInboundWorkstack Macro
    ' Add record to Inbound Workstack
    '
    
    '
        Range("A3:I3").Select
        ActiveWindow.ScrollColumn = 2
        ActiveWindow.ScrollColumn = 3
        ActiveWindow.ScrollColumn = 2
        ActiveWindow.ScrollColumn = 1
        Selection.Copy
        Sheets("Inbound Workstack").Select
        ActiveWindow.ScrollRow = 45
        ActiveWindow.ScrollRow = 44
        ActiveWindow.ScrollRow = 43
        ActiveWindow.ScrollRow = 41
        ActiveWindow.ScrollRow = 38
        ActiveWindow.ScrollRow = 34
        ActiveWindow.ScrollRow = 31
        ActiveWindow.ScrollRow = 27
        ActiveWindow.ScrollRow = 24
        Range("A26").Select
        Selection.End(xlDown).Select
        ActiveCell.Offset(1, 0).Range("A1").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        ActiveCell.Offset(0, 9).Range("A1").Select
        Sheets("AddRecord ").Select
        ActiveCell.Rows("1:1").EntireRow.Select
        Application.CutCopyMode = False
        Selection.ClearContents
        ActiveCell.Select
    End Sub
    Happy Easter!
    Last edited by Dremzy; 04-20-2014 at 01:10 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Executing a bouncing sheep whilst the code/macro runs
    By mike_vr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2013, 08:21 AM
  2. Worksheet_Change Runs Differently When Data Entered vs. Cell Cleared
    By danderson2692 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2013, 02:39 PM
  3. [SOLVED] code behind the command button that runs another macro
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2012, 06:04 AM
  4. Replies: 2
    Last Post: 04-18-2006, 02:45 PM
  5. [SOLVED] Halt all code while macro runs
    By TimT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2005, 12:05 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