Microsoft Office

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...
Posted in MS Excel

Calculation of work experience, using the DATEDIF function

If an employee record is required, Excel can be used for automatic calculation using the DATEDIF function. Obs:…

Continuare...
Posted in MS Access VBA

Retrieving in a textbox, via VBA, a value calculated by an aggregate function

If it is necessary to display the result of a query that uses certain functions (SUM, AVERAGE, MIN,…

Continuare...
Posted in Microsoft Office MS Excel

Conditional Formatting Depending on the Condition of a Column

Conditional formatting adds in the analysis of data from a spreadsheet. To apply a conditional formatting rule on…

Continuare...