How to learn Process Logic...???

[zach007]

Dear Experts,

I just want to know and learn...where/what is the best source of learning the process logic please..???... For instance, this codes:

newRow.Cells(2).Range.InsertAfter Text:=txt_num.Text
newRow.Cells(3).Range.InsertAfter Text:=txt_floor.Text

is there any good way to learn: why I have to put newRow and when I should put "." and why I chose Cells with (2). and so on...it is difficult for beginner I think...Has anyone know where to learn this process logic please...???

Thanks a lot,

Jennifer

[DKenny]

Zach
Great question.

I would start by learning the differences between each of the following.
1/ Collections
2/ Objects
3/ Properties
4/ Methods
5/ Events

You really need to understand what each of these 5 elements are and how they relate to each other.

For example a Collection element only has 1 property and 3 methods.
The property is
.Count
The methods are
.Add
.Remove
.Item

And that's it for collections, nothing else to learn, (well maybe the For Each..Next construct...), you now can fully harness any specific case of this element.



Once you have a really strong understanding of these 5 elements, the next thing you need is to understan the specific cases of these elements in the application that you are working in.
Once you understand what an object is, then you have a much better chance of understand a specific object.
The best way to learn the specifics elements in your application is to start using the Object Browser (it really is you friend).In every VBA environment this tool, when used properly, can give you all that you need to know about a specific case of any one of these elements.

Also, the browser gives you a direct link to the help file entry for a specific element.Don't be afraid to use the help files, the majority of questions in the Office Development forum could be answered in the help files - if you have done your homework on the 5 basic elements.

[zach007]

Hi,

Thanks very much for your kind helps...

Is there any good source or URL address to learn that one please...???