Results 1 to 8 of 8

Add Property to UserForm via class module - please help

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,946

    Add Property to UserForm via class module - please help

    Hi,

    I have problem writing class module and connect it to my Userform (in attachment my macro)

    My userform is called "FormyAnulacji" and i want to add to them one more property:

    FormyAnulacji.Rows = it will be LastRowStatement.

    Class Module:

    Public Property Let Rows(wiersz As Long)
        lRows = wiersz
    End Property
    
    Public Property Get Rows() As Long
        Rows = lRows
    End Property
    For example my property Rows = 10.

    So i want to set this property like this in module:

    FormyAnulacji.Rows = 10

    and next FormyAnulacji.show

    and inside my userform i should have this property which i can set up once again in userform.

    Or maybe I can do it directly in userform (not use module?)

    So goal:
    Write additional property to my userform in order to use it inside all buttons and listbox within userform.

    Please help,
    Best Regards,
    Jacek Antek
    Attached Files Attached Files
    Last edited by jaryszek; 08-18-2016 at 07:16 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Userform ComboBox Class Module not working
    By rodgersmg in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-24-2016, 03:23 AM
  2. [SOLVED] Userform & Dynamic Controls & Class Module
    By sarndt01 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 09-18-2014, 01:53 PM
  3. Replies: 0
    Last Post: 03-08-2014, 08:02 AM
  4. Replies: 1
    Last Post: 10-12-2012, 04:36 AM
  5. [SOLVED] Userform Match - unable to get the match property of the worksheetfunction class - Help!
    By Tayque_J_Holmes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2012, 11:01 AM
  6. [SOLVED] ComboBox class .AddItem filled in class module
    By Jacques Grobler in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-03-2012, 05:48 AM
  7. Replies: 1
    Last Post: 08-30-2011, 02:23 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