+ Reply to Thread
Results 1 to 2 of 2

Using Second Userform for User Input

  1. #1
    Registered User
    Join Date
    07-29-2007
    Posts
    24

    Using Second Userform for User Input

    Hi,

    I have written some code that searches a range of cells for ">". If ">" is found, a second userform pops up and says:

    "You have censored values in your dataset, please advise how you wish to deal with them".

    This second userform has three command buttons that the user can press, depending on how he/she wishes to proceed. Only one option can be selected, and on selection I would like to revert back to the original code which is stored within one of the command buttons on the first userform. Basically I just want to pass the selection option (which command button was pressed) to the code in the first userform. I made an attempt with the code below, but it doesn't appear to work. Does anyone have any ideas how I could make this work? Thanks so much for your time.

    Regards,
    James


    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Using Second Userform for User Input

    In userform1 module put something like:
    Please Login or Register  to view this content.
    then in the userform2 module:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ben Van Johnson

+ 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