Date
1 - 5 of 5
Working with Macros in Excel Spreadsheets?
Clement Chou
Hi all. Just trying to figure something out... in a workbook I'm
reading for a menu guide for an audio device, there are combo boxes to select the different menus which I want to be displayed as tables. However when I make my selections, even though the combo boxes are accurately reflecting my changes, the tables don't switch and stay at defaults. Is there something I am missing? Or is there another program I can use to accomplish other than excel 2016? The document is below just for reference in case someone wants to see what I mean. Thanks! https://www.dropbox.com/s/tacwsjzbne56a6h/GR-55-Settings.xlsm?dl=0 |
|
Craig
Hi.
toggle quoted message
Show quoted text
Without looking at your example I would use a vlookup formula Cheers C -----Original Message-----
From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of Clement Chou Sent: Monday, 9 July 2018 12:40 PM To: nvda <nvda@nvda.groups.io> Subject: [nvda] Working with Macros in Excel Spreadsheets? Hi all. Just trying to figure something out... in a workbook I'm reading for a menu guide for an audio device, there are combo boxes to select the different menus which I want to be displayed as tables. However when I make my selections, even though the combo boxes are accurately reflecting my changes, the tables don't switch and stay at defaults. Is there something I am missing? Or is there another program I can use to accomplish other than excel 2016? The document is below just for reference in case someone wants to see what I mean. Thanks! https://www.dropbox.com/s/tacwsjzbne56a6h/GR-55-Settings.xlsm?dl=0 |
|
Clement Chou
You're going to have to explain a bit more than that... because I have
toggle quoted message
Show quoted text
no idea what that is. lol. This same document is perfectly accesible in excel when using JAWS, however. I just wanted to see if anyone knew what the issue was and if there was a way to do it with NVDA. On 7/8/18, Craig <electronno@...> wrote:
Hi. |
|
Jim Homme
Hi,
toggle quoted message
Show quoted text
To open combo boxes, you need to use Alt + Down Arrow. On my computer, once I hit Enter to make a selection, NVDA stops talking. The easiest way to get it to behave properly is to maximize the sheet. This happens for me after every use of an Excel dropdown. It has happened for a very long time. Jim ========== Jim Homme Product Manager Digital Accessibility Bender Consulting Services 412-787-8567 https://www.benderconsult.com/our%20services/hightest-accessible-technology-solutions People with disabilities, access job openings at https://www.benderconsult.com/careers/job-openings -----Original Message-----
From: nvda@nvda.groups.io [mailto:nvda@nvda.groups.io] On Behalf Of Clement Chou Sent: Sunday, July 8, 2018 11:10 PM To: nvda <nvda@nvda.groups.io> Subject: [nvda] Working with Macros in Excel Spreadsheets? Hi all. Just trying to figure something out... in a workbook I'm reading for a menu guide for an audio device, there are combo boxes to select the different menus which I want to be displayed as tables. However when I make my selections, even though the combo boxes are accurately reflecting my changes, the tables don't switch and stay at defaults. Is there something I am missing? Or is there another program I can use to accomplish other than excel 2016? The document is below just for reference in case someone wants to see what I mean. Thanks! https://www.dropbox.com/s/tacwsjzbne56a6h/GR-55-Settings.xlsm?dl=0 |
|
Clement Chou
I can get the combo boxes to work properly and browse choices, but the
toggle quoted message
Show quoted text
page doesn't seem to ever reflect those changes. Wondering if someone could look at the document in question? On 7/9/18, Jim Homme <jhomme@...> wrote:
Hi, |
|