Results 1 to 3 of 3

call private sub from module

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,173

    call private sub from module

    Is it possible to call a Private Sub from another Module?

    Sub GroupPreference_10Year()
        Call ColumnSort_10Year
        Filter = 10
        Target.Column = 18
        call private sub Worksheet_BeforeDoubleClick
    End Sub
    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    
    Dim i               As Long
    Dim LastRow         As Long
    Dim MaturityValue   As String
    Dim Color           As Long
    Last edited by maacmaac; 08-13-2009 at 10:02 AM.

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