Consulting

Results 1 to 2 of 2

Thread: Need Help with Error Message

  1. #1
    VBAX Regular
    Joined
    Mar 2014
    Posts
    18
    Location

    Need Help with Error Message

    Public const AllowedTime As Double = 120 'Number of minutes to count down
    When I try to run the above code I get a compile error that states:
    Compile Error:
    Constants, fixed-length strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules
    I saw this code on another forum which seemed to work with other users. I running Excel 2010. thank you.

  2. #2
    VBAX Mentor
    Joined
    Jul 2012
    Posts
    398
    Location
    declare it in a standard module.
    why double ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •