+ Reply to Thread
Results 1 to 5 of 5

Compile Error : Invalid outside procedure is popped

  1. #1
    Registered User
    Join Date
    06-11-2019
    Location
    Indonesia
    MS-Off Ver
    2007
    Posts
    2

    Compile Error : Invalid outside procedure is popped

    Good Afternoon, i'm new in VBA but need to hide some rows based on value in specific cell. i already made this code but if i run the code using alt+f8
    Compile Error : Invalid outside procedure is popped. Can u help me ? thanks

    Sub Contoh11_1()
    If Range("E14").Value = Range("E170") Then

    'Menyembunyikan baris

    Rows("39:40").Hidden = True

    Else
    'Menampilkan baris

    Rows("39:40").Hidden = False

    End If


    End Sub

  2. #2
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    3,258

    Re: Compile Error : Invalid outside procedure is popped

    I put your code on a sheet button, altered the ranges so I could see, it worked for me.
    entered values in E1 & E2, it differeniated between same and different values.
    Please Login or Register  to view this content.
    Just noticed your first line calling "Sub" ????????
    Last edited by torachan; 06-11-2019 at 03:10 AM.

  3. #3
    Registered User
    Join Date
    08-19-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Compile Error : Invalid outside procedure is popped

    You can try this code:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-11-2019
    Location
    Indonesia
    MS-Off Ver
    2007
    Posts
    2

    Re: Compile Error : Invalid outside procedure is popped

    Can i use this code ? or i need to change something ?

  5. #5
    Registered User
    Join Date
    08-19-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Compile Error : Invalid outside procedure is popped

    Yes, of course. You can also change the Target.Value to Cells(1,"E") if you want to be specific. Target.Value if you wanted to input value to any cell.

+ 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. Compile Error: Invalid Outside Procedure Error
    By pschris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2015, 01:51 PM
  2. Run time error '5': Invalid procedure call or argument getting error
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2014, 04:48 AM
  3. “Compile error: Invalid Outside Procedure”
    By Rajeshkumar R in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-26-2013, 04:32 AM
  4. [SOLVED] Compile Error: Invalid Outside Procedure
    By packet25 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-13-2013, 07:02 AM
  5. Invalid Outside procedure error
    By rmagers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2010, 08:45 PM
  6. invalid outside procedure error
    By trum01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2009, 07:20 AM
  7. Compile Error: Invalid outside procedure
    By smylod in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2009, 01:56 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