Learning about Parameters
Parameters are variables that being passed to a Sub.
Look at the first line of the Command Button's Click event:
Private Sub Command1_Click()
And at the first line of the Command Button's KeyPress event:
Private Sub Command1_KeyPress(KeyAscii As Integer)
The Click event's first line is ended with
empty parentheses () and the KeyPress event's first
line is ended with (KeyAscii As Integer)
What is the (KeyAscii As Integer) ?
It's a parameter that been passed to the KeyPress event.
This parameter is an Integer variable with the name KeyAscii.
Like if you've declared Dim KeyAscii As Integer
Why do we need this variable?
Because its value is very useful.
The KeyPress event is being executed when the user
press a key, and This variable holds the Ascii value of the
key that been pressed.
With This Ascii value you can know on which key
the user has pressed.
For example, the Ascii value of the "A" character is 65.
If the user has pressed the key "A" on the keyboard,
The KeyAscii parameter value will be 65.
Lets see an example.
Insert the following line to the Command1 KeyPress event:
Private Sub Command1_KeyPress(KeyAscii As Integer)
Print KeyAscii
End Sub
Run the program and press several keys.
You will see the Ascii value of every key you're pressing.
Notice that the KeyAscii values of "A" and "a" are differents.
Every characters has its own KeyAscii value,
and 2 characters that are the same letter, but have different case,
have different KeyAscii value.
Popular Posts
-
SQL Hosting is a web hosting plan featuring one or more SQL databases. Having SQL database backend is essential for most of the modern websi...
-
SQL Tutorial Table of Contents SQL Tutorial Learn what SQL (Structured Query Language) is, and where and how it is used. SQL Table SQL Datab...
-
The SQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certai...
-
The SQL SELECT statement is used to select data from a SQL database table. This is usually the very first SQL command every SQL newbie learn...
-
The SQL BETWEEN & AND keywords define a range of data between 2 values. The SQL BETWEEN syntax looks like this: SELECT Column1, Column2,...
-
SQL aliases can be used with database tables and with database table columns, depending on task you are performing. SQL column aliases are u...
-
SQL Replication term describes a group of technologies allowing information distribution and mirroring between different databases. SQL repl...
-
The SQL SELECT INTO statement is used to select data from a SQL database table and to insert it to a different table at the same time. The g...
-
The SQL ORDER BY clause comes in handy when you want to sort your SQL result sets by some column(s). For example if you want to select all t...
-
The SQL COUNT aggregate function is used to count the number of rows in a database table. The SQL COUNT syntax is simple and looks like this...
No comments:
Post a Comment