Process holes in Microsoft Excel and Microsoft Access

%3CLINGO-SUB%20id%3D%22lingo-sub-1410355%22%20slang%3D%22en-US%22%3EProcess%20holes%20in%20Microsoft%20Excel%20and%20Microsoft%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1410355%22%20slang%3D%22en-US%22%3E%3CP%3EGoodmorning%20everyone.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20report%20two%20%22important%22%20process%20holes%20on%20two%20Microsoft%20products%20that%20are%20very%20popular%20worldwide!%3C%2FP%3E%3CP%3EI%20state%20that%20I%20am%20amazed%20that%2C%20although%20these%20products%20have%20been%20on%20the%20market%20for%20several%20years%2C%20they%20do%20not%20yet%20have%20these%20important%20features%20(I%20do%20not%20think%20I%20am%20the%20first%20in%20the%20world%20to%20complain%20of%20their%20shortage).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EThe%20first%20process%20hole%20concerns%20Microsoft%20Excel%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Ethere%20is%20no%20(or%20I%20do%20not%20know%20despite%20my%20laborious%20searches%20on%20the%20web)%20any%20type%20of%20functionality%20that%20allows%20me%20to%20access%20a%20%22simple%22%20list%20of%20worksheets%20contained%20in%20a%20folder.%3CBR%20%2F%3EI%20better%20explain%20the%20need!%3C%2FP%3E%3CP%3EIf%20there%20are%2015%20sheets%20in%20the%20workbook%2C%20to%20move%20%22quickly%22%20from%20one%20sheet%20to%20another%2C%20I%20am%20forced%20to%20click%20on%20the%20scroll%20arrows%20between%20sheets%20or%20to%20navigate%20between%20the%20sheets%20using%20the%20shortcut%20keys%20CTRL%20%2B%20PageDown%20or%20CTRL%20%2B%20PageUp.%3C%2FP%3E%3CP%3EBut%20if%20I%20wanted%20to%20switch%20from%20the%20current%20sheet%20(example%20sheet%201)%20to%20sheet%20number%2011%2C%20how%20can%20I%20do%20it%3F%3C%2FP%3E%3CP%3EThere%20is%20no%20functionality%20(to%20my%20knowledge)%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3CP%3EA%20drop-down%20list%20of%20the%20following%20type%20would%20suffice%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel.jpg%22%20style%3D%22width%3A%20232px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193755iF10253BC5FF3B604%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22excel.jpg%22%20alt%3D%22excel.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3Ethat%20allows%20me%20to%20quickly%20switch%20to%20the%20desired%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EThe%20second%20process%20hole%20concerns%20Microsoft%20Access%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Ethere%20is%20no%20(or%20I%20do%20not%20know%20despite%20my%20laborious%20searches%20on%20the%20web)%20any%20type%20of%20functionality%20that%20allows%20me%20to%20format%20the%20text%20in%20the%20%22Visual%20Basic%22%20(VBA)%20section.%3CBR%20%2F%3EThis%20would%20be%20fundamental%20for%20those%20who%20develop%20frequently%20as%20it%20is%20of%20fundamental%20importance%20for%20example%20to%20make%20common%20some%20sections%20of%20the%20code%20in%20order%20to%20associate%20them%20mnemonically%20and%20then%20quickly%20identify%20them%20in%20case%20of%20revision%20of%20the%20code%20itself%20(it%20would%20be%20enough%20to%20implement%20the%20highlighting%20of%20the%20text%20with%20color)%20.%3CBR%20%2F%3EI%20ask%20the%20experts%20if%20I%20made%20two%20requests%20that%20are%20impossible%20to%20implement%20(or%20can%20I%20hope%20for%20a%20future%20release%20that%20contains%20these%20two%20features)%3F%3C%2FP%3E%3CP%3EThanks%20for%20your%20attention!%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1410355%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Goodmorning everyone.

I would like to report two "important" process holes on two Microsoft products that are very popular worldwide!

I state that I am amazed that, although these products have been on the market for several years, they do not yet have these important features (I do not think I am the first in the world to complain of their shortage).

 

The first process hole concerns Microsoft Excel:

there is no (or I do not know despite my laborious searches on the web) any type of functionality that allows me to access a "simple" list of worksheets contained in a folder.
I better explain the need!

If there are 15 sheets in the workbook, to move "quickly" from one sheet to another, I am forced to click on the scroll arrows between sheets or to navigate between the sheets using the shortcut keys CTRL + PageDown or CTRL + PageUp.

But if I wanted to switch from the current sheet (example sheet 1) to sheet number 11, how can I do it?

There is no functionality (to my knowledge) :(

A drop-down list of the following type would suffice:

excel.jpg
that allows me to quickly switch to the desired sheet.

 

The second process hole concerns Microsoft Access:

there is no (or I do not know despite my laborious searches on the web) any type of functionality that allows me to format the text in the "Visual Basic" (VBA) section.
This would be fundamental for those who develop frequently as it is of fundamental importance for example to make common some sections of the code in order to associate them mnemonically and then quickly identify them in case of revision of the code itself (it would be enough to implement the highlighting of the text with color) .
I ask the experts if I made two requests that are impossible to implement (or can I hope for a future release that contains these two features)?

Thanks for your attention!

Regards

0 Replies