+ Reply to Thread
Results 1 to 3 of 3

how to make them work togheter" Marco`s "

  1. #1
    Registered User
    Join Date
    11-03-2020
    Location
    Norway
    MS-Off Ver
    Excel
    Posts
    45

    how to make them work togheter" Marco`s "

    i`m new to macro`s .. and woundring how to make 2 macros working togheter.. since i dont know that much about it, and dont know how to make 2 work in 1 sheet! here is the macros


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 1 Then
    'disable events to stop changes made by this macro re-trigering it
    Application.EnableEvents = False
    'test if changed cell is a number
    If IsNumeric(Target.Value) Then
    'only add a date if no date in column I
    If Not IsDate(Range("B" & Target.Row).Value) Then
    Range("b" & Target.Row).Value = Format(Date, "YYYYDDMM")
    End If
    End If
    're-enable events
    Application.EnableEvents = True
    End If
    Exit Sub

    'error handler
    ErrHnd:
    Err.Clear
    're-enable events
    Application.EnableEvents = True
    End Sub



    If Target.CountLarge > 1 Then Exit Sub
    If Target.Column = 1 Then
    Target.Offset(, 6).Value = Target.Offset(, 5).Value
    End If

    End Sub

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,876

    Re: how to make them work togheter" Marco`s "

    Please respond to the outsatanding moderator's request here:

    https://www.excelforum.com/excel-for...ml#post5428277

    from AliGW at Post 3.

    NO HELP TO BE PROVIDED until this is complied with.
    Glenn



  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,876

    Re: how to make them work togheter" Marco`s "

    May I respectfully suggest that you take a moment to read the Forum rules. You agreed to abide by them, but it seems you show them little or no respect. This is your final warning. Failure to comply with BOTH outstanding Moderator requests will lead to a short-term ban from the Forum.

    We have just found out that you have posted the same question elsewhere.... and haven't told us. Feel free to cross-post on other sites...

    But. Every forum has its rules. Please see Forum Rule #3 about cross-posting. So.

    Do not keep it a secret. We all are willing to give you our time, freely. However, some of us (especially me!!) get very annoyed if we waste our time developing a solution for you, when you already have a nice solution elsewhere. All we ask is that you show us some respect and tell us:

    1) if you have cross-posted, and

    2) the URL of the cross posts.

    That way, those of us who don't want to waste their time can quickly check to see if you're already happy with another solution.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

+ 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. Replies: 3
    Last Post: 11-19-2020, 08:30 PM
  2. How to make it work "='C:\Users\DK-01\Desktop\["& A1 &".xlsx]Sheet1'!$A$1"
    By london7871 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-10-2019, 09:06 PM
  3. [SOLVED] Make "WeekdayName" Function Work With "dd/mm/yyyy" Format
    By KMVKMVKMV in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-30-2019, 02:30 PM
  4. Need to run "sheet 1" Marco first then automatically run "Module 1" afterwards?
    By ElmerFud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-13-2014, 08:20 PM
  5. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  6. Replies: 4
    Last Post: 01-21-2010, 01:22 PM
  7. If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ...
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2006, 08:25 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