Category Archives: Programming
How to use the MessageBox (MsgBox)
Message boxes are used for events to provide guidance, to warn about an error, to give confirmation, for a description, to oblige a choice, and for multiple other things. The Excel MsgBox function takes advantage of a library in the … Continue reading
How to use the System Shell to open files
It is possible by means the Run method associated with the CreateObject function. – The Run method runs a macro or call a function. It can be used to execute a macro written in Visual Basic or the Microsoft Excel … Continue reading
Excel – How to deselect the autocorrection option of Two-Initial Capital letters
To avoid Excel automatic corrections (e.g. MPa, with “p” that switch to be lowercase giving Mpa) that can be annoying, it is enough to do as follows: Office button → Excel Option → Proofing → AutoCorrect Options → check off “Correct metformin without rx … Continue reading