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.

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
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.

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







Jim Homme
 

Hi,
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
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,
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