MI HAYATUL ISLAM: Cell

Breaking News

Showing posts with label Cell. Show all posts

Friday, October 5, 2012

VBA Special cells

VBA special cells make your life easy, instead of writing multiple lines of code and looping the the entire range of cells, this special cell types select in less than a second.

For more info visit msdn link below.
http://msdn.microsoft.com/en-us/library/office/aa213567%28v=office.11%29.aspx

Wednesday, September 26, 2012

VBA: Cell Data Validation list to an array

The below function will be used to get list of Cell data validation and store into an array variable. This code is needed when checking the cell value as whether it is picked from the validation drop-down or the validation rule overridden by copy-paste the cell value. (Excel has this flaw, whatever the data validation you define, simply that can be overriden by clipboard data Ctrl+C Ctrl+P)

Monday, September 24, 2012

VBA Excel : Sheet Named range into Array

The below code will be used to access the list of named-range values and pass to an array variable.

Tuesday, September 4, 2012

VBA Excel: Track Cell Change

We have seen Cell Change Tracking example to track when the change has been done and who did the change, the below example is bit advanced. It will show which cell has been modified by whom and what was the previous value before the modification.

Friday, August 31, 2012

VBA Excel: Double click event in Cell

This is an alternative/interactive way instead regular drop-down list. For example in your dashboard, you are using traffic indicators, In such case you can let the users to double click to change the value of the metric. The code is below, copy & enjoy :)

VBA Excel: Cell Change Tracking

In the 'Shared workbook' environment or a workbook going through multiple levels of updation, we can track of critical cell entries. We can capture those details and hide the columns containing the data with password protection.

VBA Excel: Dynamic Data Validation List ( Nested Drop Down )

Dynamic Data Validation List ( Nested Drop Down ): The below code will be used to do 'Data Validation' through macro. I have used this particular code to populate the drop-down list in a cell based on selection in the previous cell.