| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to program on check box
Glad you found something useful!
yangyh wrote: I'd use the checkboxes from the Forms toolbar. Searching the old threads and found the following information. The check box works perfect in my program. Thank you Dave Peterson!!! ================================================== ==== Just add a checkbox to the worksheet. rightclick on it and choose Format Control on the Control tab, assign a nice linked cell (Maybe column A of the row that holds the checkbox???) Then this linked cell will be true or false depending on the "checkedness" of that checkbox. If you have to have yes/no, you could use a formula in column B (same row) that looks like: =if(a1=true,"yes","no") And if you find that column A makes the worksheet look ugly, you could always hide it when you're done creating the worksheet. -- yangyh ------------------------------------------------------------------------ yangyh's Profile: http://www.excelforum.com/member.php...o&userid=26883 View this thread: http://www.excelforum.com/showthread...hreadid=467265 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| merging excel program with tdc finance program | Excel Programming | |||
| API call to check other program is idle | Excel Programming | |||
Hybrid Mode
