Category Archives: Excel & VBA tips
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, … Continue reading
Posted in Excel & VBA tips
Tagged buttons, excel, MessageBox, MsgBox, Prompt, VBA, VbAbortRetryIgnore, VbCritical, VbExclamation, VbInformation, VbOKCancel, vbOKOnly, VbQuestion, VbRetryCancel, VbYesNo, VbYesNoCancel
Leave a comment
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 … Continue reading
Posted in Excel & VBA tips
Tagged ActiveX, CreateObject, DLL, files, Intersect, open, run, shell, Shell.dll, Shell32, system, WScript, XLL
Leave a comment
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, … Continue reading
Posted in Excel & VBA tips
Tagged autocorrection, CAPITAL, Capitals, deselect, excel, How, Initial, letter, letters, option, two
Leave a comment