Tips by Joe (Proe, Excel...)

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.

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..

Its strange that ProE does not have a ROUND function. At least I counldnt find it. It has two funtions. Ceil will always round it up. Floor will always round it down. I have used both to get the ROUND functionality. here is the relation...

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)

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....

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.