Starting from
In front of the company, meow invited the company to open the program of VBA for excel in the company. Some of the members of the above team had the program written, some have learned some Program Statement in school, but there are still many people who have no idea about program. This kind of confrontation is a challenge for teaching. The degree of knowledge varies, so it is not easy to master easily. Therefore, Xiao Meow has made this teaching material, so that some experienced readers can understand it in the shortest time, about 3 hours) you can know the basic program design. After such content, we can bring everyone's horizontal attention to the same level, so that the students do not know what Xiao Meow is doing.
Here, Xiao meow will share with you the content of the related videos.
Programming content
- What is programming
- Change Data
- A = a + 1 misunderstandings
- Sub-Program
- Event producer
- Object adequacy Method
- Incircle
What is a program?
- Actions with sort order are performed one by one
- Program Design in life: Bubble computing
- Open a bubble
- Place the bubble in a bowl
- Open the flavor package and place the seasoning in the bowl.
- Place in open water
- Soak in triples
- Complete bubble renewal
What is a program (Program feature)
- Sequential: Move rows from top to bottom
- Event producer:
- When I clap hands: Ask boys to stand up and girls to sit down
- When I speak, ask a girl to stand up and sit down.
- Program process: different conditions have different results
- Standing up at noon
- Other referers
- Re-Attention: Circle
Change Data
- Use a token to store a specific value.
- X: indicates the person who eats the timer at noon.
- Y: indicates the person who eats the week at noon.
- Variable Calculation
- Z: Total number of people who eat lunch + lunch
- Z = x + y
- Material type labels:
- Text, data, and date
A = a + 1 misunderstandings
- An invalid table in Mathematics
- Meaning on the program
- A = a + B
Sub-Program
- In common, many places use the same action.
- Chapter:
- Sub branch (specified position)
- Pick up Seal
- Expiry date
- Muyin
- Move the chapter to the specified position
- End sub
- Sub-program handling: convenient Modification
Objects, adequacy, and methods
- Object: refers to an object that exists (such as a car)
- Adequacy: used to describe the characteristics of Vehicle Information
- For example, colors, flags, heights, degrees, and durations
- Method: actions of an object
- For example, forward, backward, and backward
Objects, adequacy, and methods in Excel
- Excel is a collection of many objects
- The object contains the object.
- There are many worksheets in the Excel worksheet case
- There are many memory cells in the worksheet.
- Features: Describes features or content.
- Text in the escape cell: range ("A1"). Text
- Method: One action
Meaning of the circle
- Fast Power Supply
- Re-upload the email
- Repeat the line in the program → repeat the circle
- Circle types:
- Known count:
- Condition settings
- While .... Wend
- Do... Loop while
- Do... Loop
Loop (... Next)
- Known repeated times
- Fixed Number of duplicates
- Example: clap hands for five times
Loop (while vs)
- Determined by the condition.
- Example: clap your hands until I say stop
- While:
- When
- Set incircle content
- Conformity → content
- Non-conforming → open
- Until:
- Until
- Set the Enable ring Condition
- Non-conforming → internal
- Yes → open
Loop (while vs)
|
Italian |
Set a condition |
Conformity |
Non-conforming condition |
While |
When |
Incircle |
Internal |
Open |
Until |
Until |
Open circle |
Open |
Internal |
Circle (do... Loop)
- While/until before: first judge and then enter the circle
- Do while... Loop
- Do... Loop
- While/until after: first in and then judge again
- Do... Loop while
- Do... Loop
Circle (do... Loop)
- Until: Until → set the condition
- Non-conforming items → incircle
- Compliant with the condition → open the loop
- Example:
- Clap your hands until I say stop
- Do
- Loop until (I said stop)
Loop (while... Wend)
- Equivalent to do while... Loop
- Example: The number of each shot is as small as 5.
- X = 1
- While (x <= 5)
- Clap hands
- Data (x = x + 1)
- Wend
PS.
- the above content is the internal content of the proposal. When it comes to practice, we also need examples and students to cooperate with the notebook (standing up, sitting down, and clapping ), the workload allows students to understand what programming is based on examples of life and activity.
- because the goal of the students is to test the skill assignment, there are more details about the circle, if you are a real-time employee, you only need to pick up a token for while/Until.