How to set up an option button?

[hp383]

Hi folks, new here so I hope this is in the right place.

I am trying to set up a purchase option sheet. This will allow a sales
person to go through and select various options for a product we
build.

I am hoping to end up with a workbook that i can print out, showing all
selected options, and the costs associated with each option.

This way, I in the engineering dept can have a better ide of what it is
Im supposed to design. I cant tell you how tired I am of seeing a work
order/proposal that reads " to be determined by customer", or "Just
like the one you built for me 2 years ago".

Please, any help would be great... heck I would even consider hiring a
fluent Excel user to help me get this set up.

But I do want to learn how, just not sure if this is a good task for a
begginer.

Thanks!

 

[Harald Staff]

Hi

Option buttons and other ActiveX'es are awkward to set up so they blend in
with worksheet cells. I suggest you use Data Validation for this instead.
Download and test Debra Dalgliesh's file "Purchase Order" at
http://www.contextures.com/excelfiles.html
and read the tutorials starting at
http://www.contextures.com/xlDataVal01.htm
to see how it's done.

HTH. Best wishes Harald