Excel File Recovery

How to Control Data Capture with a VBA Form in Excel

User capture into a spreadsheet is difficult to police; the entry point could be anywhere, and even locking of some cells provides no focus on the part of the user. A User Form with validation can provide an orderly channel for data capture into a spreadsheet. The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google “Excel Developer Tab” or “Excel Code Window”. Objective To produce the following form, which writes...

Read more »

How to Fix Dates in Your Excel Worksheet with VBA

How often do we get dates in spreadsheets supplied to us as 12.26.2016, or 26/12/2016 (UK format), only to be told the date is invalid or there's no month 26? This article explores fixing dates with VBA, using TRIM, LEFT, RIGHT and MID functions. The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window". The xlsm in this exercise can be downloaded here. Not Our Problem! The...

Read more »

8 Common Formula Errors in Excel

Excel formulas in Excel is able to help you finish some rather complex tasks. But you will certainly meet with formula errors in Excel. In this article, we will show you the 8 formula errors in Excel. There are many reasons that will cause formula errors in Excel. For example, you are not familiar with the rule of a certain function, or there is something wrong with the referred cells. In the following parts, we will demonstrate the 8 formula errors with some examples. 1.   ...

Read more »