16Jun2015

How to Browse and Select File and Folder in VBA

Browse and select file in VBA : Sometimes, we may need to work with external files in Microsoft Excel. We might need a button in excel to open windows file dialog box so as to select the desired file. To achieve this we need to write the following code in VBA editor.   VBA Code Snippet:
  • 16 Jun, 2015
  • Excel for Commerce
  • 0 Comments
  • Browse and Select File and Folder in VBA, Excel Consultant, Excel Expert,
Read more
21May2015

INSTRING function in VBA

Instring function in VBA returns the position of the first occurrence of a substring. This function can be used to find whether the search string (Sub string) is present in a string. Syntax:  InStr( [start], string, substring, [compare] ) Start: It is the starting position for the search. If this parameter is omitted, then default
  • 21 May, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, instring function,
Read more
27Mar2015

Split Function in VBA

How to use SPLIT function in VBA Split function in VBA is used to split a text string based on a delimiter. This delimiter can be a special character like “,”, ” -“, “&”  or even text delimiters like “and”, “or”, “the”, “sample” etc. For example, lets takes a data set with Employee name, Designation
  • 27 Mar, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, split function,
Read more
29Jan2015

Get combobox selected value in Excel VBA

There are three methods to read the selected values from a combobox in VBA. Please go through the following blog to know how you can do it. Method 1: Consider, we have a dropdown list having days mentioned in it. The value selected in the dropdown is ‘Sunday’. Now, we will try to read the selected
  • 29 Jan, 2015
  • Excel for Commerce
  • 0 Comments
  • Combobox Selected value, Dropdown value,
Read more
29Sep2014

Enable Macros for Excel VBA Files

Macros in Microsoft Excel should be enabled to run Excel file with macros. Following blog will help us in understanding how to do it. Let’s open the Microsoft Excel File which contains Macros (they are also called as VBA code).  When this type of file is opened, Excel pops up a warning notification as “Protected
  • 29 Sep, 2014
  • Excel for Commerce
  • 0 Comments
  • macros, vba,
Read more