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
06Jan2015

Microsoft Access – How to run a macro when database opens?

Microsoft Access allows the users perform a set of actions every time a database loads or opens by creating a macro called ‘AutoExec’. You can run a macro when database opens by naming it as ‘AutoExec’ or calling the ‘AutoExec’ macro. As the name suggests, an ‘AutoExec’ macro is a macro that automatically executes the actions we
  • 6 Jan, 2015
  • Excel for Commerce
  • 0 Comments
  • Access, AutoExec,
Read more
01Jan2015

How to sort horizontally in Excel? (from left to right)

Sorting horizontally in Excel: Sorting horizontally in excel (from left to right) is required when we have a table/data as shown in the image below. In the below image, we want to sort horizontally based on employee name. This blog explains how to sort multiple columns horizontally from left to right. Let’s take a sample
  • 1 Jan, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Sort horizontally in Excel,
Read more