Tips by Joe (Proe, Excel...)

Search This Blog

Printing the Books, the Old school way.

September 18, 2008

Get link
Facebook
Twitter
Pinterest
Google+
Email
Other Apps

I have this video of the The Old School Printing Method. Interesting, to say the least. Check out.

design related news

Get link
Facebook
Twitter
Pinterest
Google+
Email
Other Apps

Comments

TreeView Structure in Excel VBA

.

Last Few days I was working on a TreeView Structure and thought I will share the knowledge I gained...

This post takes you through the basic operations to create and operate a TreeView.
It will be like the Folder tree window of the windows explorer.

1. Get the additional control for the TreeView:

Get to the VBA Window, Right Click on the ToolBox Window and Select Additional Controls... --- Browse through the window and select "Microsoft TreeView Control ...." and "Microsoft ImageList Control ....". --- Now these two items would have come in your TooBox. --- Select and place it on the Form and start working.

2. Name the Tree:

I have changed the name of the tree to TV from the default TreeView1. Hereon, I will use TV for that item.

3. Build the Tree up:

You build tree by adding nodes. You can add a node as a Child or a Parent etc.. I like to use the relationship - Child.

Basically, each node has a Key (like the name of controls), Text (like the Caption of control…

Proe Function / Relation to round the decimal places

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

Excel Function :TABLE

Its been a while since I have done some posting. This option in excel is something which I thought would be very useful for many.

Its the TABLE Function in MS Excel. This is especially useful in the following scenarios.

Powered by Blogger