+ Reply to Thread
Results 1 to 2 of 2

calling another procedure after clicking userform event

  1. #1
    Registered User
    Join Date
    12-13-2020
    Location
    vskp, india
    MS-Off Ver
    windows10, office2007
    Posts
    35

    calling another procedure after clicking userform event

    I have an userform which will be activated from module. I have declared required public and local variables in module code . Userform is showing all details as expected. Now i want to run another subroutine with option button click event and The subroutine should use variables already declared during initialization procedure. Is it require to pass all the required variables to userform which inturn to use in sub procedure? Even If yes/no, Please help me to proceed further.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: calling another procedure after clicking userform event

    It sounds like you have an option button on the userform, and you want to add a sub to run when the option button is clicked.

    The OptionButton_Click sub can reference the variables that are declared at the top of your UserForm module.

    We can give a more detailed answer if you show all your existing code, plus describe what you want the Click sub to do.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Get Caption From Userform CommandButton During Click Event Procedure
    By skywriter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2015, 02:53 AM
  2. Calling Procedure or Function inside another Procedure - variables problem
    By Rudo123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2015, 03:12 PM
  3. Replies: 0
    Last Post: 10-02-2012, 03:06 PM
  4. How to look backwards from a userform to the calling procedure's error handling
    By deucejmp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2012, 04:55 AM
  5. [SOLVED] Is there a command to exit a for loop in a sub procedure from a userform event?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2012, 10:50 AM
  6. Problem in calling a function at intialize event of userform
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2010, 07:54 AM
  7. [SOLVED] Calling an embedded items event procedure from within a normal module
    By jase in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2005, 09:05 AM

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