How to use Click Button

**rajjana** · 01-28-2016, 08:46 AM

Friends,

how to use Click button mine requirement in attached excel sheet.

**BadlySpelledBuoy** · 01-28-2016, 08:56 AM

Link the radio buttons to a cell (in the attached I've linked them to A1).
This cell will show a number that corresponds with which button is selected.
Then use a nested IF to show the results dependent on that cell.
Or, if you have many different buttons and many different values you could use a lookup table.

See attached.

BSB

How to use Click Button

LinkBack

Thread Tools

Rate This Thread

Display

How to use Click Button

Re: How to use Click Button

Thread Information

Users Browsing this Thread

Similar Threads

Running the code in an option button from a seperate normal button click

Button Click on Spreadsheet commanded by Button Click on Userform

[SOLVED] Hide And Unhide Column With One Button,,,,Once Click Hide,,,,,Again Click Unhide

[SOLVED] click on a color button and after button click it will color entire row of cell you click

[SOLVED] How do I run the macro for a button click without clicking the button?

Call button click event from a button on anther sheet

[SOLVED] [SOLVED] Create floating button based on button click in menu

Bookmarks

Bookmarks

Posting Permissions