A File dialog box allows you to choose one or more files from a folder in your computer. You can open a file dialog box from your Excel worksheet using VBA. Microsoft Excel’s “.FileDialog” method of ...
You can dynamically change column width or the row height in your Excel worksheet using simple properties in VBA. It becomes necessary when you have texts or data in columns that either hides or over ...
I have previously shared an article with an example showing how to open a word document from excel and copy excel data, a table, to the word doc using VBA. You can reverse the process, that is ...
I only use a plug-in in my applications only when I don’t find easy methods to do things. No doubt, a Plug-in offer features that will help customize your apps. You can find many plug-in that would ...
It is very easy to add text to shapes dynamically in Excel using VBA, provided you know the properties. VBA’s “Shape” object provides a property called “TextFrame”, which gives access to the text of ...
PSAT (Preliminary Scholastic Aptitude Test / NMSQT) is a standardized exam that is taken by the high school students as a preliminary SAT. This is also a qualifying exam for the National Merit Scholar ...
You can insert different kinds of shapes in your Excel worksheet, like a circle or a rectangle etc. These shapes can be used for various purposes and you can easily change its properties like ...
The angular team has released Angular 6 recently and it comes with many interesting tools and features. I am still updating my Angular 4 projects to Angular 6. The AutoComplete feature in Angular ...
We use Arrays to store multiple values or data. It’s a very convenient way to store data temporarily in a single variable, till the job is done. There would be situations where we want to search a ...
The JavaScript “replace()” method can be used to replace value in a string with a given value. However, if the value that you are trying to replace occurs more than once in the string, for example ...
A File dialog box allows you to choose one or more files from a folder in your computer. You can open a file dialog box from your Excel worksheet using VBA. Microsoft Excel’s “.FileDialog” method of ...August 2, 2018Continue Reading
I only use a plug-in in my applications only when I don’t find easy methods to do things. No doubt, a Plug-in offer features that will help customize your apps. You can find many plug-in that would ...July 10, 2018Continue Reading
PSAT (Preliminary Scholastic Aptitude Test / NMSQT) is a standardized exam that is taken by the high school students as a preliminary SAT. This is also a qualifying exam for the National Merit Scholar ...July 6, 2018Continue Reading
The angular team has released Angular 6 recently and it comes with many interesting tools and features. I am still updating my Angular 4 projects to Angular 6. The AutoComplete feature in Angular ...July 2, 2018Continue Reading