I am searching for VBA code that would provide the following…

From Sheet1… Execute a Command Button that displays a matrix.
The Matrix, is a list of products with a range of prices.
I would like the user to select the cell for the product and price they want to use in Sheet1.


(See attached picture)
For Example Sheet1…. (Little squares to the right represent command buttons) The command button would execute the User Form or

Matrix Cell Selection.jpg



UserForm or Array….

The user would have the ability to select any cell, ie; Prism Edge, Price-3, and the product description and price would be pulled into Sheet1. (Prism Edge, 40.00)

Are there VBA examples available? Is this even possible? Any ideas?

Fred M.

Thank you!