Tag Archives: VisualBasic

Customizing the editor for coding

A lot of people hate software just because they do not like the look and feel of the user interface. Surprisingly even the knowledgeable “geeks” have strong preferences on the GUI (Graphical User Interface). This often takes away the focus from functionality and versatility of programs and impact negatively on high-quality products.

Continue reading Customizing the editor for coding

Extract data from rows for email

If you are a teacher or a professor, you probably have several students in your class. Let’s say you would like to provide them with an update on their averages after every single quiz and exam they take. But you hate to email each and everyone of them because it consumes a lot of time to copy data from your Excel file of student records to individual emails. This is where the extract data from row by row using loop iteration comes to save you.

Continue reading Extract data from rows for email

Visual Basic Script using the Interface

This is the second article a ongoing series of VB scripting guide. If you are unfamiliar with programming in Microsoft Excel, don’t be afraid, start your journey into VisualBasic with basics of VB explained here.

Macro recorder is great for those who are new to the coding in general. A user can utilize the graphical front end of Excel to generate Modules, which can be modified using conventional VBA Editor.

Continue reading Visual Basic Script using the Interface

Excel Visual Basic Scripts

A simple program like Microsoft Excel 2010 can be used as a powerful tool by manipulating the software. Microsoft has published several “how to” guides such as this one Getting Started with VBA in Excel 2010. They are very good articles, and I am not trying to beat them. After all, they wrote the software anyway. I just want to introduce Excel as a powerful programing tool for home users Continue reading Excel Visual Basic Scripts