Adding a button to Excel, need help please

  • Thread starter Thread starter yash
  • Start date Start date
Y

yash

Hello, i'm new to this excel VBA stuff and I was wondering if a
kind soul could help me out, i've got a spreadsheet with lots of
different values, but i have a few cells that take YES/NO as their
value, so what i want to do is to put 2 option buttons to change
the values in these cells to either yes or no by choosing a button.
But I havent the slightest clue how to, well I lie I can add a
button but I dont know what code to put, no doubt it's something
really simple, but so far ive not found any help on it. Thank you!
 
If you select the forms toolbar, then select two option
buttons,right click the first and it allows you to record
select the cell where you want yes to appear and type Yes, end
the recording. Now right click the other option button and carry
out the same excercise this time typing No. this is in excell 2003
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need urgent help 0
need help on excel vba please :ActiveWorkbook.FollowHyperlink Address:="TextBox1.Text" 5
Capturing YES/NO from two option buttons 3
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
radio button help 3
Selecting Radio Buttons by Using Macros 2
Adding a Custom Command Button to the Excel 2007 Ribbon 1
Excel Forms Spin Button - Return to 1 after max value 0

Back
Top