Skip to main content


Showing posts from 2009

Treeview Structure in VB.Net

In this post, we will look at how the Treeview can be used. I am using Visual Basic 2008 Express Edition. In one of my earlier posts , I had explained in detail about Treeview in Excel-VBA. Through this post, I would like to bring the VB.Net way of the control.

search and find all supressed features in proe

How to find all supressed objects in Proe (Pro Engineer) easily.. Yes, its easy.. no manual search is needed... Thanks to to ProE seach method..

How to use VLookUp in Microsoft Excel.

Tool : MS Excel. Topic : The function - VLOOKUP. This is a very useful function to extract data from the table. Microsoft says.. "Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table." The format. VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

How to Start with VB Programming (VBA) in MS Excel

Excel is like a vast ocean....  The possibilities of using VB (VBA to be precise) is almost endless  But it’s not too complicated (to do simple stuff) if you put bit of an effort and with a small programming background.  Let me try to help you to get started....

Basics of Excel functions and relations.

Through this post, I would like to introduce the Built in Functions of Microsoft Excel to a beginner. Let me put some excel functions that could be of use to those who what to make a start. Before touching upon some of the functions, some introductions. The first thing that I would recommend for a beginner is to browse through the list of functions and its uses. At this stage, forget how it to be used, but keep an eye one what all you can do using functions. For that, go to INSERT -> FUNCTIONS. You will see the following dialog. Here you can either select ALL, or a specific category like TEXT. Now select a function and at the bottom, you will see what it will do. To find more detailed explanation, click HELP ON THIS FUNCTION. Note: Click the cell with Function(s) and press F2 and you will be able to see the references in different colors.