Need help on creating a Pop-up text menu once a cell is touched

[alex_a]

I have a table named "category table" showing a numeric value for product classification as follows:
Severity Classification
1 Safe Product, No Contamination
2 Safe Product, Possibility of Contamination
3 Unsafe Product, Trace of Contamination
4 Unsafe Product, Extensive Contamination
5 Unsafe Product, Shut Down Operation

In another worksheet, I have product list:
Product Status
A (need to see the product table pop-up once the cell in the status category is touched)
B
C
D
E
F
G
H

I' like to know whether there is a way when status cell is clicked, the category table is popped up and the numeric value is entered in the status cell

[rvasquez]

Hello there,

Attached is a workbook that I believe accomplishes what you are looking for. To begin make sure to enable macros and content. Then, to test it out select the worksheet "ProductList". Then double click on a Product (cells 2 throguh 8). This will bring up userform. Double click on category, this will populate the Status cell and exit the form.

To use this in your workbook, open up your workbook in the same excel window as the workbook I have provided you. Press Alt+F11 to bring up Visual Basic. In Visual Basic you should see on the left VBAProject(yourworkbookname.xls) and then another one named VBAPoject(alex.xls). under the VBAProject(alex.xls) Click on the userform1 under the forms folder and drag it the Microsoft Excel Objects under VBAProject with your workbook name. Next double click on the worksheet name that contains your product list. It will appear list Sheet1(you worksheet name) in the VBA window(under mine it's Sheet1(ProductList)).

Right click on the Userform you inserted into your document(i.e. the one you just dragged) and select View code. I have left some comments for you. You'll need to change the worksheet names to fit your workbook.



Copy and paste the below code into the white space provided.

Please Login or Register  to view this content.

Exit out of VBA and you can close the workbook I supplied you and should be able to begin working with yours.

[rvasquez]

An easier way to do this might just to provide a drop down list in Column B cells.

[Winon]

Hello alex_a,

By creating a Named Range for Categories, and a little other change, I think that you will now find that what rvasquez offered you could provide for a wider scope as to what a DropDown could do with its "fixed range" could do for you, since you will have to adjust it as the Range could grow.

Try the attached WB, and see how good a job rvasquez actually started with

[alex_a]

Hello alex_a,

By creating a Named Range for Categories, and a little other change, I think that you will now find that what rvasquez offered you could provide for a wider scope as to what a DropDown could do with its "fixed range" could do for you, since you will have to adjust it as the Range could grow.

Try the attached WB, and see how good a job rvasquez actually started with

Thanks for the outstanding solution. Great job Winton and rvasquez. The problem has been solved!

[Cutter]

@ alex_a

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Winon]

@ Cutter,

Thank you for your response to this Thread. It may be a good idea to make it a "Sticky" since there are many OP's that don't mark their Threads as solved