VBA

Posted in MS Excel VBA

The lowest and highest value simultaneously formatted

If we have several intervals where we want to highlight, through conditional formatting, the lowest and the highest…

Continuare...
Posted in MS Word VBA

Remove own styles at once

Sometimes, if we have to format various retrieved documents, we may realize that the phrase “better to redo…

Continuare...
Posted in MS Word VBA

Letter spacing button

To be able to use it in all Word files, you can work directly in the normal.dotm template….

Continuare...
Posted in MS Excel VBA

Worksheet dynamization

I appreciate some features that I have used in specific applications where, for example, the width of a…

Continuare...
Posted in MS Access VBA

Decimal Truncation

In MS Access, there may be situations, more rarely, when you don’t want to round some numerical values…

Continuare...
Posted in MS Excel Projects VBA

Automatic rounding for a range of cells

If it is desired that, in a sheet, numerical values be formatted and displayed by rounding with a…

Continuare...
Posted in MS Access VBA

Proper Text in MS Access

Excel has the default function Proper, which allows the ability to display only the first letter of a…

Continuare...
Posted in MS Access VBA

Calculating seniority up to a certain year

Let’s assume that knowing the date of employment, we would be interested in the seniority of employees (in…

Continuare...
Posted in MS Access VBA

Multiselect filtering in the form, using ListBox

Single Form To achieve the desire in the title it is required a table, a form and a…

Continuare...
Posted in MS Access VBA

Timed PopUp message in Ms Access

There are situations in which using certain actions need to display a message, but do not involve our…

Continuare...