Activex Option Button - link to multiple cells depending on input from another cell?

[scrawltome]

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!

 

[scrawltome]

Never mind - I wasn't very clear and I've solved it myself. I changed the Activex Option Button to a Form Field one and it was then able to take 'input' from a cell. I, then set up a cell elsewhere that had my criteria in it, that then linked to the Option Button linked cell. I don't know if that makes any sense whatsoever - sorry!