+ Reply to Thread
Results 1 to 4 of 4

Properties of class not showing in the object browser or after the ".".

  1. #1
    Registered User
    Join Date
    05-30-2012
    Location
    California, USA
    MS-Off Ver
    Office 365
    Posts
    26

    Properties of class not showing in the object browser or after the ".".

    I have made a class module with 2 properties and they appear in the list box after the ".". I then added several more in the same fashion as the previous two but they do not show up as properties, only the first two that were made.
    [code]
    Implements clsEquipment

    Public EquipmentType As String
    Public EquipmentUsage As String
    Public OperatingSchedule As String
    Public Floor As String
    Public Manufacturer As String
    Public ModelNumber As String
    Public Tonnage As String
    Public YearManufactured As String
    Public EfficiencyNew As String
    Public Row As Long
    Private Function clsEquipment_GetRow() As Long
    clsEquipment_GetRow = Row
    End Function
    Private Function clsEquipment_SetRow(irow As Long)
    Row = irow
    End Function
    Private Function clsEquipment_GetType() As String
    clsEquipment_GetType = EquipmentType
    End Function
    Private Function clsEquipment_SetType(activecell As String)
    EquipmentType = activecell
    End Function
    Private Function clsEquipment_GetUsage() As String
    clsEquipment_GetUsage = EquipmentUsage
    End Function
    Private Function clsEquipment_SetUsage(activecell As String)
    EquipmentUsage = activecell
    End Function
    Private Function clsEquipment_GetOperatingSchedule() As String
    clsEquipment_GetOperatingSchedule = OperatingSchedule
    End Function
    Private Function clsEquipment_SetOperatingSchedule(activecell As String)
    OperatingSchedule = activecell
    End Function
    Private Function clsEquipment_GetFloor() As String
    clsEquipment_GetFloor = OperatingSchedule
    End Function
    Private Function clsEquipment_SetFloor(activecell As String)
    clsEquipment_GetFloor = activecell
    End Function
    [code]
    Last edited by chipnputt; 12-23-2013 at 09:17 PM. Reason: going to post code

  2. #2
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: Properties of class not showing in the object browser or after the ".".

    Can you fix the tags please.

    Make sure all your functions are set to public
    Please Login or Register  to view this content.
    and not
    Please Login or Register  to view this content.
    Thanks
    Last edited by fredlo2010; 12-23-2013 at 09:52 PM.

  3. #3
    Registered User
    Join Date
    05-30-2012
    Location
    California, USA
    MS-Off Ver
    Office 365
    Posts
    26

    Re: Properties of class not showing in the object browser or after the ".".

    They are all public

  4. #4
    Registered User
    Join Date
    05-30-2012
    Location
    California, USA
    MS-Off Ver
    Office 365
    Posts
    26

    Re: Properties of class not showing in the object browser or after the ".".

    fredlo2010 - Thank you for making me check my code, I looked for several hours and read it as public. Good catch, my bad!! Thanks again, chipnputt.

+ 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. VBA Object Browser "View Definition" icon is grayed out
    By RonByrd in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 05-14-2013, 04:18 AM
  2. [SOLVED] Very small AutoFill macro showing "AutoFill methode of range class failed" why ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 10:21 PM
  3. [SOLVED] Scroll Bar missing "Control" tab in "Format Properties" dialog box
    By Peter Rooney in forum Excel General
    Replies: 5
    Last Post: 02-14-2012, 01:45 AM
  4. Refreshing Object Properties after "Set"
    By Ken McLennan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2005, 01:05 AM
  5. Replies: 0
    Last Post: 09-13-2005, 12:05 PM

Tags for this Thread

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