+ Reply to Thread
Results 1 to 2 of 2

Create Userform from Module

  1. #1
    Registered User
    Join Date
    07-19-2024
    Location
    USA
    MS-Off Ver
    Office 16
    Posts
    1

    Create Userform from Module

    I'm looking for a way to create a UserForm that will be generated when a VBA Module is ran instead of having to load the UserForm itself. I already have the code written for the command button "Enter" but am having trouble finding articles online on how to create the code for creating the form. Thanks for any help you guys can provide!
    Attached Images Attached Images

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,399

    Re: Create Userform from Module

    attached a demo of a similar app that I gave some time ago.
    Note the minimalistic code require to construct and manipulate the results - this is handled by the Class module - there are no controls on the form at the design stage.
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

+ 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. Place code in userform, module or class module
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2017, 07:04 AM
  2. [SOLVED] Close userform from module(!)
    By Alexander_Golinsky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2013, 12:31 PM
  3. how to access Sheet module, normal module, Worbook module to type code
    By alibaba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2009, 07:51 AM
  4. Create a macro (module?) that activates in my userform code?
    By Bafa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2008, 09:15 PM
  5. How to call a sub from UserForm Module
    By Myles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2006, 11:40 PM
  6. [SOLVED] Userform and Module
    By magix in forum Excel General
    Replies: 9
    Last Post: 12-18-2005, 01:30 PM
  7. Userform/Module
    By saziz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2005, 08: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