Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a button to Excel, need help please
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! ---------------------------------------------- Posted with NewsLeecher v1.0 Final * Binary Usenet Leeching Made Easy * http://www.newsleecher.com/?usenet ---------------------------------------------- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a button to Excel, need help please
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 "yash" wrote: 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! ---------------------------------------------- Posted with NewsLeecher v1.0 Final * Binary Usenet Leeching Made Easy * http://www.newsleecher.com/?usenet ---------------------------------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a Button | Excel Discussion (Misc queries) | |||
adding a command button to an excel cell? | Excel Discussion (Misc queries) | |||
Adding a button | Excel Programming | |||
adding button for add-in | Excel Programming | |||
adding button for add-in | Excel Programming |