POP-UP Menu using VBA and UserForms

**alex_a** · 08-25-2012, 12:32 PM

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.

**MarvinP** · 08-25-2012, 12:37 PM

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.

**alex_a** · 08-26-2012, 12:00 AM

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.

**MarvinP** · 08-26-2012, 12:07 AM

See if this helps your code.

**alex_a** · 08-26-2012, 02:10 AM

Marvin,

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

**alex_a** · 08-28-2012, 03:06 PM

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.