Awards
Join OfficeTipsAndMethods

Have some suggestions to share with the world?

Join OfficeTipsAndMethods and share your insight in a Comment. You must be a member to comment and all comments are moderated before being published. Membership is free and we would never share your personal information with anyone.

Become an OTM Member

Log In

YouTube Video Channel
OfficeFix
Article Categories

Posts Tagged ‘developer tools’

Five Essential Excel Keyboard Shortcuts

Some keyboard shortcuts are designed to enhance your productivity in specific applications. Here are five that have long been my favourites in Excel.

 

<ctrl>;

Insert the current date. The inserted date will remain the same; it does not update when Excel recalculates formulas.

<shift><ctrl>:

Insert the current time. The inserted time will remain the same; it does not update when Excel recalculates formulas.

<ctrl>HOME

Move the selection to the beginning of the worksheet. Cell A1 becomes the active cell. Note: if freeze panes is in effect, the shortcut behaves a little differently, making the top left cell of the lower right quadrant active. If Row 1 contains the header of a structured table, <ctrl>HOME will select cell A2 rather than A1.

<ctrl>END

Selects the cell at the lower right corner of the portion of the worksheet that has actual contents.

F4

When entering formulas, make a cell reference absolute. Each time you press F4 when you are entering a formula the absolute reference changes from Absolute Cell or Range to Absolute Row/Relative Column to Absolute Column/Relative Row to Relative Cell or Range

Links for the technically inclined:

Announcing the Microsoft Cloud Roadshow

https://microsoftcloudroadshow.com/cities/?Wt.mc_id=dx_MVP400580

This is a free, two day technical training event for IT Professionals and Developers that provides best practices and insight from those who run cloud services across Office 365, Micros oft Azure, and Windows 10.

Developer Interview Series #1 –

The Power of Cross Platform Development with Universal Apps and Xamarin

https://channel9.msdn.com/Blogs/Case-Studies/The-Power-of-Cross-Platform-Development-with-Universal-Apps-and-Xamarin?WT.mc_id=dx_MVP400580

In this interview series, we bring you best practices, anecdotes, and insights from developers who are building creative solutions using Microsoft technologies.

We’re on the road to self-driving business applications

http://blogs.msdn.com/b/stevengu/archive/2015/09/09/we-re-on-the-road-to-self-driving-business-applications.aspx?WT.mc_id=dx_MVP400580

A blog by Steve “Guggs” Guggenheimer on self-driving ERP (Enterprise Resource Planning software)

Memory Compression in Windows 10 RTM

https://channel9.msdn.com/Blogs/Seth-Juarez/Memory-Compression-in-Windows-10-RTM?WT.mc_id=dx_MVP400580

The OS is doing some clever optimizations that allow your processes to trim some of the memory but not necessarily page it out to disk.

Managing hidden apps, beta apps and visibility of in-app purchases in Dev Center

http://blogs.windows.com/buildingapps/2015/09/10/managing-hidden-apps-beta-apps-and-visibility-of-in-app-purchases-in-dev-center/?WT.mc_id=dx_MVP400580

The unified Dev Center introduced several new options to manage the visibility of apps and in-app purchase.

Developing for Windows 10

The recent advent of Windows 10 has brought with it a wealth of development resources and tools.

At the top of the list, of course, is Visual Studio 2015. Click Visual Studio Downloads to download any of the Visual Studio skus.

You can find all the information you need to develop Windows 10 apps by following these links:

Microsoft Virtual Academy offers online courses for Windows 10 and there is some great content on Channel 9. Microsoft Virtual Academy also offered a Windows 10 Jumpstart on August 14th. This event has ended but an on demand version should be available soon.

Happy developing!

Tools for the VBA Developer

Thomas Möller of Team-Moeller has very kindly given permission to publish this commented  list of VBA development tools.

 

Tool-Name: TM VBA-Inspector

Author: Thomas Möller

URL: http://www.team-moeller.de/en/?Add-Ins:TM_VBA-Inspector

Purpose: Examine VBA-Code to find hidden faults and bad coding styles

 

Add. Info: For additional information refer to the help file and

this post on the Access Team Blog:

http://blogs.office.com/b/microsoft-access/archive/2010/09/30/enhance-the-quality-of-your-vba-code.aspx

 

 Tool-Name: MZ-Tools 3.0 for VBA

Author: Carlos J. Quintero

URL: http://www.mztools.com/v3/download.aspx

Purpose: Great number of functions to make coding easier

 

Add. Info: You can attach a function to a shortcut

Options dialog / Shortcuts / Add "Search" to CTRL+F

 

Add. Info: You can easily rename a variable or a procedure:

  • Double click in variable name

  • Start Find-Dialog (CTRL + F) / Start search

  • Insert new name

  • Select each item and hit "Replace"

Tool-Name: VBE Tools v2.0

Author: Office Automation Ltd

URL: http://www.oaltd.co.uk/VBETools/Default.htm

Purpose: Bigger ‘Location’ label in References dialog

 

Add. Info: Start the options dialog. Check "Resize ‘Location Label’

on Tools / References dialog"

 

Tool-Name: Smart Indenter v3.5

Author: Office Automation Ltd

URL: http://www.oaltd.co.uk/Indenter/Default.htm

Purpose: Indent the whole code in a procedure, in a module or

in the whole project with one mouse click

 

Add. Info: Have a look at the options dialog. It shows directly

how the chosen options will indent your VBA-Code

 

 Tool-Name: TM VBA-ToDoFinder

Author: Thomas Möller

URL: http://www.team-moeller.de/?Add-Ins:TM_VBA-ToDoFinder

Purpose: Find ToDo’s in your VBA-Code

 

Add. Info: Tool and website is available only in German language

(But there is less UI – so check it out)

 

Add. Info: Put your ToDo’s as a comment to your VBA-Code

For example: ‘ToDo: Optimize this loop

Start ToDo-Finder and hit the Refresh-Button

 

 

 Tool-Name: Procbrowser

Author: Sascha Trowitzsch

URL:

http://www.mosstools.de/index.php?option=com_content&view=article&id=58:procbrowser&catid=34:accesstools

Purpose: Browse through the procedures of a code-module

 

Add. Info: You find the button for download at the end of the website

 

Add. Info: Start the tool: Add-Ins / Procbrowser

Change the language: Context menu / "Sprache" / "Englisch"