To Extract Number only from String in MS Excel We will use a VBA function to extract all numbers from text string in Excel. The steps are follows: Step1: At first open MS Excel workbook and then click on “Visual Basic”… Read moreTo Extract Number only from String in MS Excel

Sometimes we forget the VBA project password. However, when we need to code in VBA project, we have to remove the password and put new password. To remove the password please follows steps: Step-1: Open the Access database file by… Read moreRemoving Password from MS Access VBA Project

Use the below function to truncate data in VBA Access

Sometimes we need to write multiline in the msg box. For that reason follow the below code: