I've been asked to create a list of elements from a database with the following requirements: the elements have to be arranged hierarchically and there have to be a possibility to collapse/expand them by levels. The structure of the database is set by levels, ie. 1st column = the highest level, 2nd column = the lower level, ..., the last column = the lowest level.
Featured post
Working with two monitors
Working with two monitors is realy great. There are keyboard shortcuts in Windows 7 that make the work with them much easier and faster ...
Showing posts with label Immediate window. Show all posts
Showing posts with label Immediate window. Show all posts
2015-09-04
How to create an outline from a database
I've been asked to create a list of elements from a database with the following requirements: the elements have to be arranged hierarchically and there have to be a possibility to collapse/expand them by levels. The structure of the database is set by levels, ie. 1st column = the highest level, 2nd column = the lower level, ..., the last column = the lowest level.2015-01-14
Easy and quick formula translation
Are you using a localized version of MS Office? Did you find a formula with the English names of functions? You can translate each function in the formula manualy or you could use Immediate window in VB editor.