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: <https://support.office.com/en-US/Article/Create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b> 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 <https://support.office.com/en-US/Article/Sort-our-data-in-the-order-you-want-it-to-appear-f92f26c6-470d-4b09-a0e9-e5c3b60a8a7a#__toc246836970> 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 <https://support.office.com/en-US/Article/remove-the-table-formatting-60d1796b-fd79-4dde-8983-e7ed54148a2a> , and then try step 5 again. o The worksheet might be protected or shared. Remove the protection <https://support.office.com/en-US/Article/Remove-the-protection-54fedd95-28dc-4abc-a26c-6566917c1a59> 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] <mailto:[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 <http://www.aheartstaffing.com/> <http://www2.freedomscientific.com/training/JAWS-Certified-Individuals.asp> A Heart Staffing PO Box 1277 Franklin, VA 23851 Direct: 757-346-0708 www.aheartstaffing.com <http://www.aheartstaffing.com/> www.linkedin.com/in/aheartstaffing <http://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] <mailto:[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 <mailto:[email protected]> Sent: Thursday, February 18, 2016 7:05 PM To: [email protected] <mailto:[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 <mailto:[email protected]> To: [email protected] <mailto:[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 <mailto:[email protected]> To: [email protected] <mailto:[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. <https://www.avast.com/sig-email> www.avast.com This email has been sent from a virus-free computer protected by Avast. <https://www.avast.com/sig-email> www.avast.com
