+ Reply to Thread
Results 1 to 7 of 7

Pass values from UserForm ListBox/ TextBox to run the codes of a Module

  1. #1
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Thumbs up Pass values from UserForm ListBox/ TextBox to run the codes of a Module

    Hi All,

    Can anyone please help me out with the correct method of passing values from a UserForm to the Module (written codes)?

    I just want to load the UserForm & run the codes via using shortcut keys (Ctrl + k), so this methodology can give me a freedom to run the codes on any worksheet, which is active.

    Please see my codes and help me:-
    I am unable to populate all the worksheet names in a list box by UserForm_Initialize.
    I am unable to pass values from UserForm to the module. I Just want to setect anyone of them in the ListBox, so that the Module codes {Variance_Finder} should be run on that paticular worksheet


    I tried with a TextBox too instead of the above ListBox. It shows me the ActiveWorksheet Name, where I want to run my codes via shortcut keys (Ctrl + k), but the appeared worksheet name doesn't passes from UserForm to the Module, so the codes do not work at all.

    Please help to have a perfect tuning between the UserForm and Module Codes.


    Thanks in advance!

    Please see below, is the attached sample in MS Excel 2007:
    Attached Files Attached Files
    Last edited by SunOffice; 09-05-2011 at 09:11 AM.
    Excelforum is Completely Awesome! True learning with Live Examples & Best Techniques!!

  2. #2
    Valued Forum Contributor mohd9876's Avatar
    Join Date
    05-04-2011
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2010
    Posts
    426

    Re: Pass values from UserForm ListBox/ TextBox to run the codes of a Module

    to populate all the worksheets in the userform use this code
    Please Login or Register  to view this content.
    and to pass data from the userform to the code you should specify the userform's name before the list box name like this
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Re: Pass values from UserForm ListBox/ TextBox to run the codes of a Module

    Thank you for ur quick reply and help!!

    It is working; but when I use Keyboard Shortcut (Ctrl + k) to run this it runs again and again, and don't select the right worksheet.

    Please check-out below updated attached.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor mohd9876's Avatar
    Join Date
    05-04-2011
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2010
    Posts
    426

    Re: Pass values from UserForm ListBox/ TextBox to run the codes of a Module

    the problem is in your submit button you are calling the same macro that shows the userform that is why it runs infinitely; so your code for submit button should be like this:
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Re: Pass values from UserForm ListBox/ TextBox to run the codes of a Module

    Thank you mohd9876!

    Yeah! I tried with your method and works fine, but I don't know why the Cancel button doesn't work; codes surprisingly run after clicking on 'Cancel' button.

    I have made a new UserForm...and the same as above I tried with a TextBox, which shows the active worksheet name to run the codes on that (Keyboard Shortcut: Ctrl + m). It work fine when I click on Enter button, but doesn't stop on clicking Exit button.


    Please see my updated workbook of the same and help me out.
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor mohd9876's Avatar
    Join Date
    05-04-2011
    Location
    Amman, Jordan
    MS-Off Ver
    Excel 2010
    Posts
    426

    Re: Pass values from UserForm ListBox/ TextBox to run the codes of a Module

    Check the attached workbook
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Thumbs up Re: Pass values from UserForm ListBox/ TextBox to run the codes of a Module

    Thanks a world Mr. mohd9876!!

    I just tried ur awesome tricks with another module (with ListBox method), and working fine ...WOW!!

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

    Quick and Awesome Trick!! Thank you so much!!
    Attached Files Attached Files
    Last edited by SunOffice; 09-05-2011 at 09:40 PM. Reason: Debug: added the first line for safe running of the codes.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06644 seconds
  • Memory Usage 9,029KB
  • Queries Executed 15 (?)
More Information
Template Usage (33):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (7)bbcode_code
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (7)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (5)postbit_attachment
  • (7)postbit_legacy
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (48):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • bbcode_parse_start
  • postbit_imicons
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1