Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox1 linked to sheet1 a1
how will i get a value in sheet1 cell a1 when putting a tick in checkbox1?
if checkbox1 got tick in cell a1 should read "dayend failed" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox1 linked to sheet1 a1
Link the checkbox to a cell via the checkbox properties, and check the cell
value with a simple IF test. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pswanie" wrote in message ... how will i get a value in sheet1 cell a1 when putting a tick in checkbox1? if checkbox1 got tick in cell a1 should read "dayend failed" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox1 linked to sheet1 a1
thanx.. got that sorted out. (there wouldnt be a way to program the checkbox
so that instead of true if ticked it says dayend completed and instead of false it say dayend incomplete "Bob Phillips" wrote: Link the checkbox to a cell via the checkbox properties, and check the cell value with a simple IF test. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pswanie" wrote in message ... how will i get a value in sheet1 cell a1 when putting a tick in checkbox1? if checkbox1 got tick in cell a1 should read "dayend failed" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkbox1 linked to sheet1 a1
No, it reruns just those values.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pswanie" wrote in message ... thanx.. got that sorted out. (there wouldnt be a way to program the checkbox so that instead of true if ticked it says dayend completed and instead of false it say dayend incomplete "Bob Phillips" wrote: Link the checkbox to a cell via the checkbox properties, and check the cell value with a simple IF test. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pswanie" wrote in message ... how will i get a value in sheet1 cell a1 when putting a tick in checkbox1? if checkbox1 got tick in cell a1 should read "dayend failed" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated | Excel Programming | |||
Copy from file1 sheet1/file2 sheet1 last blank row | Excel Programming | |||
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
Sheet1.Activate vs Sheet1.Select | Excel Programming | |||
Checkbox1.LinkedCell = ActiveCell "Why wont this work?& | Excel Programming |