Thank you!!! Dr. Jeanette McAllister 757-346-0708
Sent from my iPhone > On Feb 19, 2016, at 3:12 PM, HH. Smith Jr. <[email protected]> wrote: > > By the way, I did follow the directions and created a drop list using > Excel2016, Windows10, JAWS17 > > From: HH. Smith Jr. [mailto:[email protected]] > Sent: Friday, February 19, 2016 4:08 PM > To: [email protected] > Subject: Re: Excel, drop down boxes, and JAWS > > Hi Jeanette, > > I got these instructions straight from Microsoft: > Provide a more efficient worksheet by using drop-down lists in a cell where > your customers can make a yes or no choice, pick a date from a calendar, or > pick from another list you insert. Someone using your worksheet clicks an > arrow, and then clicks an entry in the list. > > > > 1. On a new worksheet, type the entries that you want to appear in your > drop-down list. The entries should be in a single column or row without any > blank cells, like this: > > > > Tip Now is a good time to Sort our data in the order you want it to appear > in your drop-down list. > > 2. Select all of your entries, right-click, and then click Define Name. > > 3. In the Name box, type a name for your entries, for example, ValidDepts, > and then click OK. Be sure your name doesn’t have any spaces in it. This name > won’t show up in your list, but you need to name it so you can link it to > your drop-down list. > > > > 4. Click in the cell in the worksheet where you want the drop-down list. > > 5. Click Data >Data Validation. > > > > Tips Can’t click Data Validation? Here are a few reasons why that might > happen. > > o Drop-down lists can’t be added to tables that are linked to a SharePoint > site. Unlink the table or remove the table formatting, and then try step 5 > again. > > o The worksheet might be protected or shared. Remove the protection or > stop sharing the worksheet, and then try step 5 again. > > 6. On the Settings tab, in the Allow box, click List. > > 7. In the Source box, type and equal sign (=), immediately followed by the > name you gave your list in step 3. For example, =ValidDepts. > > > > 8. Check the In-cell dropdown box. > > 9. If it’s OK for people to leave the cell empty, check the Ignore blank > box. > > 10. Click the Input Message tab. > > 11. If you want a message to pop up when the cell is clicked, check the > Show input message when cell is selected box, and type a title and message in > the boxes (up to 225 characters). If you don’t want a message to show up, > clear the check box. > > > > 12. Click the Error Alert tab. > > 13. Check the Show error alert after invalid data is entered box, pick an > option from the Style box, and type a title and message. If you don’t want a > message to show up, clear the check box. > > > > Not sure which option to pick in the Style box? > > o To show a message that doesn’t stop people from entering data that isn’t > in the drop-down list, click Information or Warning. Information will show a > message with this icon and Warning will show a message with this icon . > > o To stop people from entering data that isn’t in the drop-down list, > click Stop. > > Note If you don't add a title or text, the title defaults to "Microsoft > Excel" and the message to: "The value you entered is not valid. A user has > restricted values that can be entered into this cell." > > > > From: Jeanette McAllister [mailto:[email protected]] > Sent: Friday, February 19, 2016 9:10 AM > To: [email protected] > Subject: Excel, drop down boxes, and JAWS > > I have a question. I cannot get drop down boxes in Excel to read. JAWS will > tell me there’s a drop down box and tell me how to access it, and then he > just says “blank”. I had a sighted individual tell me there is text in the > drop down box for selection. I called Freedom Scientific and I was told this > is an excel problem. I was told I could press tab and then shift tab and JAWS > would read it; it does NOT work. I have a student who needs this to do her > job. Does anyone know of any keystrokes I can teach her to get JAWS to read > what is in the drop down box? > > My student is using JAWS 16 and Excel 2013. > > Thank you, > Jeanette McAllister PhD > President / CEO > Assistive Technology Tutor > > > A Heart Staffing > PO Box 1277 > Franklin, VA 23851 > Direct: 757-346-0708 > www.aheartstaffing.com > www.linkedin.com/in/aheartstaffing > > Member-National Employment Committee – NFB > http://employment.nfb.org/ > > Member- Virginia State Rehabilitation Council > Dept for the Blind and Visually Impaired > > "Don't judge each day by the harvest you reap, but by the seeds you plant." > --Robert Louis Stevenso > > From: Gerald Levy [mailto:[email protected]] > Sent: Friday, February 19, 2016 7:21 AM > To: [email protected] > Subject: Re: Weather Research It now working > > > I can confirm that Weather is now working in Research It with JAWS 16. But > to be perfectly blunt, I really don’t understand the infatuation with > Research It, anyway. Sometimes it works and sometimes it doesn’t. If the > weather option stops working again, you can always get your local weather > from Weather Underground whose forecasts and current conditions are just as > comprehensive as those provided by Research It. And Weather Underground > always works, so enter your zip code and save it in your bookmarks or > favorites list, and whenever you want your local weather, just click on it: > > http://braille.wunderground.com/ > > > > Gerald > > > > From: Joseph Weakland > Sent: Thursday, February 18, 2016 7:05 PM > To: [email protected] > Subject: Re: Weather Research It now working > > just now i keyed in my zipcode for weather research it and worked like > acharm:) > ----- Original Message ----- > From: Dave Carlson > To: [email protected] > Sent: Thursday, February 18, 2016 5:55 PM > Subject: Re: Weather Research It now working > > Yep. Working here, as well. So likely problem was that the weather web site > had some sort of glitch in its API or page layout. Hope it sticks. > > Dave Carlson > Oregonian, woodworker, Engineer, Musician, and Pioneer > ----- Original Message ----- > From: Dave Mitchell > To: [email protected] > Sent: Thursday, February 18, 2016 11:54 AM > Subject: Weather Research It now working > > Hi, Just now, the weather Research It feature seems to be working normally. > Mitch > > Statistically, 100% of the shots you don't take, > don't go in. > (Wayne Gretzky) > > > This email has been sent from a virus-free computer protected by Avast. > www.avast.com > > This email has been sent from a virus-free computer protected by Avast. > www.avast.com > > This email has been sent from a virus-free computer protected by Avast. > www.avast.com >
