+ Reply to Thread
Results 1 to 6 of 6

POP-UP Menu using VBA and UserForms

  1. #1
    Registered User
    Join Date
    01-23-2012
    Location
    houston
    MS-Off Ver
    Excel 2003
    Posts
    18

    POP-UP Menu using VBA and UserForms

    Hi,

    Several weeks ago a couple of VBA experts assisted me to create a popup menu using VBA codes and a userform. I'd like ot know how I can creat two more popup menus for different categories using forms2 and 3. I am attaching the file to better clarify my request. I am trying to duplicate the effort for the category "Occurance" and "Detectability" showing in columns B and C. I'd lilke to see the same event for these two. Thanks for your assistance.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,449

    Re: POP-UP Menu using VBA and UserForms

    Hi alex_a,

    The first error happens in the code with this line:
    With Sheets("QualityMatrics")
    The reason is you have the sheet named QualityMatrix not QualtyMatrics.

    Excel knows the difference between the two spellings.

    I won't look further until you investigate and reply.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    01-23-2012
    Location
    houston
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: POP-UP Menu using VBA and UserForms

    Hi,

    Although you were right on the worksheet discrepancy but when I corrected the worksheet name, I still have problem with the other two userforms. I am atatching the modfied version. Thanks for yoru help.
    Attached Files Attached Files

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,449

    Re: POP-UP Menu using VBA and UserForms

    See if this helps your code.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-23-2012
    Location
    houston
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: POP-UP Menu using VBA and UserForms

    Marvin,

    Thanks so much for your technical assistance. You are great!!

  6. #6
    Registered User
    Join Date
    01-23-2012
    Location
    houston
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: POP-UP Menu using VBA and UserForms

    Marvin,

    How can I disply the numeric value when the userforms are poped up (instaed of the whole text, I want the numeric value is inserted. I have attached the file with the description in the categories section. Thanks again for yoru help.
    Attached Files Attached Files

+ 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