+ Reply to Thread
Results 1 to 5 of 5

Run macro after all specific cells are filled.

  1. #1
    Registered User
    Join Date
    07-03-2014
    Location
    Colombo, Sri Lanka
    MS-Off Ver
    2013
    Posts
    10

    Run macro after all specific cells are filled.

    Hi, I'm very new to VBA and expecting proper solutions for below

    "C7:E8,C9:D11,H7:I11,L7:M8" This range to be filled with some data like name, ref no, date..... etc. what i want is, after filling these all cells with any value active window should scroll to 12, if at least one cell is not filled window should not be scrolled. I'm currently using following codes to desthis page, your solution will be able to add in to this codes. following codes I'm using

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Address(True, True) = "$H$10" Then
    Select Case Target
    Case "GYRO"
    Call Selection_gyro
    Case "SHORE BEARINGS"
    Call Selection_other_method
    Case "SUN'S AZIMUTH"
    Call Selection_other_method
    Case Else
    'Do nothing
    End Select
    End If

    If Target.Address(True, True) = "$G$29" Then
    Select Case Target
    Case "Slot"
    Call By_slot
    Case "****"
    Call By_****
    Case Else
    'Do nothing
    End Select
    End If

    End Sub

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Run macro after all specific cells are filled.

    Interesting one.

    BRB

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Run macro after all specific cells are filled.

    Hi.

    Right Click on your sheet name at the bottom of excel and select view code.

    then paste this code there.

    It will run whenever a change is made and will check all your required cells.

    If they are all filled then it will run "MyMacro"

    You will need to create MyMacro in a normal Macro module.


    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    07-03-2014
    Location
    Colombo, Sri Lanka
    MS-Off Ver
    2013
    Posts
    10

    Re: Run macro after all specific cells are filled.

    Dear Mehmetcik, Thank you for your response I've tried your solution. I thing there is some error. Here I attached sample, Please try with it and help me. Thank YouTEST.xlsm

  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Run macro after all specific cells are filled.

    Try this version:

    Private Sub Worksheet_Change(ByVal Target As Range)

    Please Login or Register  to view this content.

+ 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. Counting Cells that have a specific filled color
    By avidcat in forum Excel General
    Replies: 3
    Last Post: 07-19-2014, 11:07 PM
  2. [SOLVED] Macro to copy specific data from one WB to specific cells in another WB based on specific
    By d_rose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 11:05 AM
  3. Replies: 12
    Last Post: 07-10-2012, 05:04 PM
  4. Replies: 1
    Last Post: 10-11-2009, 04:59 AM
  5. macro to validate cells are filled before going to next row.
    By ballack in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-24-2007, 09:07 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