Moving Access Mini App to Excel
 

I have a form in Access that calculates the total value of a subassembly for
use in an estimating worksheet. Since we want to keep the underlying math
visible in Excel, the form creates a string for the formula, which we cut and
paste into the worksheet, of the form:

qty1 & "*" & unitprice1 &"+" & _
qty2 & "*" & unitprice2 &"+" & _
....
qtyn & "*" & unitpricen &"+" & _

The form has combo boxes for the ProductType and Product that gets its rows
from Access tables where we store the standard costs.

I'd like to move this form into Excel, so that the user can invoke it from
our custom toolbar or menu, and, by pressing a button, insert the formula
into the active cell. But I'd like to keep the costs in Access.

Is this possible? Can I create combo boxes within Excel that get their Rows
from Access tables?

Any help is appreciated.
Sprinks