The solution is really very well. Dropdown menus are very accessible for screen readers. I think 90% of problems are solved.
Why 90%? Becose sometimes macros are not associated to a specific plan. I have been trying to develop a xlam to make quick some interactions with screen reader. Let me give you an example. Named cells can be managed by menus, but it's not so easy to navigate among names and intervals. So I have created a macro which creates an additional plan and list in two columns the names and the corresponding addresses. This is an example of a public macro, available in any time. In these cases, I cant't use a dropdown in the selected plan. For this purpose, perhaps, it would be better to use the menu bar or the context menu. But the truth is I am already very happy with the solution yu proposed! Thank you! 2014-10-30 7:39 GMT-02:00, luciano de souza <luchya...@gmail.com>: > Hello all, > > I want to create several subrotines: macro1, macro2, macro3, macro4... > And I want to select one of then in a dialog box. > > I could add a form and add a combobox to the form. Each item of the > combo would be associated to a different subrotine. This could be a > solution for most people, but not for me. > > I am blind and I use computer by means of a screen reader. The > construction of forms requires to copy and paste objects, positioning > then on the screen. This is a task not possible to do with a screen > reader. > > But I know there is a simple dialog listbox, standard in Windows, > similar to msgbox or input box, that could be useful for me in this > case. Probabily, it's something available in user32.dll. > > My question is: does someone know how to call it? > > The ideia is: a main macro is called by means of keystroke. A simple > listbox is shown. With arrows, I select an item corresponding to > another defined macro. > > What do you can say about it? > > Best regards, > > > -- > Luciano de Souza > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Luciano de Souza -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
