Results 1 to 6 of 6

Creating a Class ?

Threaded View

  1. #1
    Registered User
    Join Date
    12-18-2006
    Posts
    36

    Question Creating a Class ?

    Ok...
    I have forms, I want them to call a module to get some info that is returned to the form...
    But I am not sure how to go about this in VBA.


    ### USERFORM1 ###
    Private Sub UserForm_Initialize()
    Call Module1.GetValues
    End Sub

    Private Sub CommandButton1_Click()
    ActiveCell.Value = something.value
    End Sub



    ### MODULE1 ###
    Sub GetValues()
    something.value = ActiveCell.Value
    End Sub


    Any help much appreciated.

    EDIT:
    I should make it clear that there are a number of forms that all need to call on the same module.
    So...
    ### MODULE1 ###
    Sub GetValues()
    UserForm1.something.Value = ActiveCell.Value
    End Sub

    wont help.
    Last edited by The_Vulcan; 02-04-2007 at 09:42 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