PC Review


Reply
Thread Tools Rate Thread

checkbox1 linked to sheet1 a1

 
 
pswanie
Guest
Posts: n/a
 
      28th Jan 2008
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 With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      28th Jan 2008
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" <(E-Mail Removed)> wrote in message
news:4798A2A9-866A-4714-95A9-(E-Mail Removed)...
> 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 With Quote
 
pswanie
Guest
Posts: n/a
 
      28th Jan 2008
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" <(E-Mail Removed)> wrote in message
> news:4798A2A9-866A-4714-95A9-(E-Mail Removed)...
> > 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 With Quote
 
Bob Phillips
Guest
Posts: n/a
 
      28th Jan 2008
No, it reruns just those values.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pswanie" <(E-Mail Removed)> wrote in message
news37811C3-7273-456F-A38E-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:4798A2A9-866A-4714-95A9-(E-Mail Removed)...
>> > 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Upload Data from Sheet1 on Local Machine to Sheet1 on LAN ryguy7272 Microsoft Excel Programming 2 3rd Jul 2008 08:40 PM
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated pano Microsoft Excel Programming 2 28th Oct 2007 02:32 PM
Copy from file1 sheet1/file2 sheet1 last blank row =?Utf-8?B?VGFzaGE=?= Microsoft Excel Programming 2 22nd Aug 2007 08:24 PM
how to retrieved value from xml to checkbox1............ Supra Microsoft Dot NET 1 3rd Aug 2004 09:34 PM
Show a sheet1 row in sheet2 based on values in col sheet1.A =?Utf-8?B?TWljaGVsbGU=?= Microsoft Excel Misc 5 4th Mar 2004 02:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:11 PM.