+ Reply to Thread
Results 1 to 10 of 10

Excel VBA Create Dynamic Userform

  1. #1
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    149

    Excel VBA Create Dynamic Userform

    Hello Genius,

    I need your help. I saw a nice USERFORMS in the attached Personal_Finance.xls spreadsheet. Looks like it's some kind of Dynamic Userform and it Look nice. i was trying to create the same kind of Userform but i could not.
    i noticed that, When I change or select the item from the combobox the description is changing too.. it's really cool. I would like to use this as well. I like to learn something new.. so could you please look into this and help me to create the same USERFORMS
    The spreadsheet is locked but i was able to cracked this and grabbed the macros.

    Please let me know the result.. Please

    Any Help will be appreciated.. attached is the original locked spreedsheet, the cracked version of the original spreadsheet and the macros.
    Attached Files Attached Files
    Last edited by raw_geek; 08-06-2015 at 10:21 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Excel VBA Create Dynamic Userform

    so could you please look into this and help me to create the same USERFORMS
    Hi -

    Why not just exporting that form into your file?

    event

  3. #3
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    149

    Re: Excel VBA Create Dynamic Userform

    I couldn't see the form in cracked excel.. After I unlocked the spreadsheet the form is disappear.. I got only macros...

  4. #4
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    149

    Re: Excel VBA Create Dynamic Userform

    nay help.. VLookup in Dynamic Userform??

  5. #5
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    149

    Re: Excel VBA Create Dynamic Userform

    any help please?

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Excel VBA Create Dynamic Userform

    There's no userform in the attached file.
    If posting code please use code tags, see here.

  7. #7
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Excel VBA Create Dynamic Userform

    Hi -

    Extract and import to your file

    event
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    149

    Re: Excel VBA Create Dynamic Userform

    Hi,


    Imported the xxxxxxx.frm file and form worked.

    Got error msg that xxxxxxxx.frx file could not be imported.

    What is .frx and how important is it ?
    Attached Images Attached Images

  9. #9
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Excel VBA Create Dynamic Userform

    Hi -

    Should be error free. I have made it for you

    event
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    149

    Re: Excel VBA Create Dynamic Userform

    Genius.. Good work .. you made my day

+ 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. [SOLVED] Create dynamic number of checkboxs on Userform
    By vamosj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2014, 06:27 PM
  2. Create Macro for dynamic set of rows in excel
    By pavanexcel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2014, 05:42 AM
  3. [SOLVED] Create a Dynamic Chart from an Excel Table
    By Elīna in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 07-29-2013, 12:45 PM
  4. How to create dynamic userform or dialog box
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-01-2010, 12:49 PM
  5. Create a dynamic UserForm
    By chamdan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2009, 10:13 PM
  6. create dynamic ddbox in excel with vb
    By john gault in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2006, 05:16 PM
  7. I want to be able to create a dynamic reference in excel, for exam
    By Lee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2006, 12:55 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