I would appreciate some help. I'm not even sure if it's possible..

I am creating a spreadsheet that can automatically generate an invoice for me, but I would like to use Option Buttons on the actual invoice.

Currently, I have it set up that if I select a certain invoice number, all the data referring to that invoice (on another worksheet) shows up on the Invoice.

My question is: can I use that sort of formula (based on the invoice number) to select the input from a certain row on another worksheet into an activex Option Button?

TIA!