Option button (active control) code to perform a calculation

**Taggsuk** · 11-18-2008, 03:31 PM

Option button (active control) code to perform a calculation on a cell reference
Hi, is it possible to choose an option button which will then perform a calculation on a cell reference? I’m trying to deduct a percentage from a total when an option button is highlighted.
I’m very new to vb, I can master how to enter details into the cell but that is all. Any help would be most appreciated.

**Leith Ross** · 11-18-2008, 03:40 PM

Hello Taggsuk,

Welcome to the Forum!

When you say "active control" are you referring to a Forms Toolbar control or an ActiveX control, which is the same as a Control Toolbox control or are uncertain which type of control to use?

Sincerely,
Leith Ross

**Taggsuk** · 11-18-2008, 03:54 PM

Hi Leith,
I'm using an option button (activex control) and all I have managed is to is select a cell and enter details ie

Please Login or Register  to view this content.

But I would really like to be able to perform a calculation on a referenced cell when the option box is clicked. So if the you clicked the option box named 50% then 50% would be deducted from the cell with the toal calculation in it.

Thanks for the quick response

**Leith Ross** · 11-18-2008, 04:05 PM

Hello Taggsuk,

You need to use the OptionButton1_Change() event to determine the state of the OptionButton, not the default OptionButton1_Click() event.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**VBA Noob** · 11-18-2008, 04:11 PM

Taggsuk,

Please read forum rules below before posting again. I've added you're code tags for you this time

Many thanks

VBA Noob

**Taggsuk** · 11-18-2008, 07:00 PM

Thank you very much, works a treat

Option button (active control) code to perform a calculation

LinkBack

Thread Tools

Rate This Thread

Display

Option button (active control) code to perform a calculation

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions