Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Checkboxs, Optionbox
How do u chagne the value of checkbox from like true or flase to a number value
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Checkboxs, Optionbox
Hi, There probably is an easier way, but I normally put an IF statement looking at the referenced cell, ie Say the check box is linked to cell A1, in B1 I would put =IF(A1=TRUE,1,2) When the check box is checked the value returned in B1 is 1, if its False its 2. I would normally place the check box over the same cell of A1 and set font in A1 to white, that way all you see is the check box and the returned valve. Hope that helps. "Brandon" wrote: How do u chagne the value of checkbox from like true or flase to a number value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |