+ Reply to Thread
Results 1 to 4 of 4

Multiple Userforms - Avoid code duplication

  1. #1
    Forum Contributor
    Join Date
    12-16-2005
    Posts
    161

    Multiple Userforms - Avoid code duplication

    I am working on a project that requires many userforms. Some forms are identical i.e. they capture the same data relating to items of equipment (price, etc). Is it possible to code this in a way that I don't have to repeat identical userforms? Any help to get me started on this would be greatly appreciated.

    Cheers

    Peter

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    You can Show the userform from any module and handle the data differently in each module, so if the userform has Textbox1 and ComboBox1 in your module you can handle UserFormx.TextBox1.Value to wherever and the same for ComboBox1 (where x is the userform number).

    Other than this suggestion i didnt really grasp what you were getting at.


    Regards,
    Simon

  3. #3
    Forum Contributor
    Join Date
    12-16-2005
    Posts
    161

    Thanks Simon

    I get it - many thanks for your help!

    Cheers

    Peter

  4. #4
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Glad to help!, if you need further assistance post back.

    Regards,
    Simon

+ Reply to Thread

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