Data collection in Excel2003
in [General]
|
From: John on 20 May 2010 08:21 Hi Linda You're welcome, glad to see you solved your problem. Cheers from Montreal. John "Lynda" <Lynda(a)discussions.microsoft.com> wrote in message news:B6434AD0-A556-4EF0-A172-30734A0AE982(a)microsoft.com... > Hi John, > > Thank you for your help. I have managed to fix my problem with the text box, > so no need to worry about it. > > Thank you so much. Cheers, Lynda > > "John" wrote: > >> Hi >> > Each Check Box can be link to a cell, that will give you a "True" /" False" >> > reply that you can count. >> >> I should have said; " That you can use a formula to count the "True" and >> "False" >> eg: =COUNTIF(A2:A50,"True") >> >> Regards >> John >> >> "John" <johnd(a)newlook.com> wrote in message >> news:u799tz49KHA.4316(a)TK2MSFTNGP04.phx.gbl... >> > Hi Linda >> > Maybe this can help: >> > Each Check Box can be link to a cell, that will give you a "True" /" False" >> > reply that you can count. >> > To link them, right click on the CheckBox and Format Control, then look >> > under >> > the Control Tab. >> > HTH >> > John >> > >> > "Lynda" <Lynda(a)discussions.microsoft.com> wrote in message >> > news:282F9CFE-146A-4AA2-8967-F263F3E035BC(a)microsoft.com... >> >> Hi everybody, >> >> >> >> I created an evaluation form some time ago in Excel 2003. Originally it >> >> was >> >> sent out to people after they had completed their training. It went out to >> >> about 5-6 people so gathering the information was not a very huge task. >> >> Now >> >> the form has been sent out to over a hundred people and I need to come up >> >> with something easier to capture the data. >> >> I used Forms-check boxes to answer the questions, then I had a comments >> >> area >> >> beside each question and I used the Forms-Text Box with a scroll bar. >> >> I am asking, is there an easier way to collect this data? >> >> Cheers >> >> Lynda >> > >> >> . >> |