I want to make a library in excel from VBA i need to put 3 things 1) INSERT 2)DELETE 3)UPDATE from the insert thing, i have to enter a record into excel, from delete, i want to delete the whole record and from update i have to ba able to call a value i entered from insert and change it so. 11 Events: Events are actions performed by users which trigger Excel VBA to execute code. 12 Array: An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the index number. 13 Function and Sub: In Excel VBA, a function can return a value while a sub cannot.
-->Runs a specified procedure when a particular key or key combination is pressed.
Syntax
expression.OnKey (Key, Procedure)
expression A variable that represents an Application object.
Parameters
Name | Required/Optional | Data type | Description |
---|---|---|---|
Key | Required | String | A string indicating the key to be pressed. |
Procedure | Optional | Variant | A string indicating the name of the procedure to be run. If Procedure is ' (empty text), nothing happens when Key is pressed. This form of OnKey changes the normal result of keystrokes in Microsoft Excel. If Procedure is omitted, Key reverts to its normal result in Microsoft Excel, and any special key assignments made with previous OnKey methods are cleared. |
Remarks
The Key argument can specify any single key combined with Alt, Ctrl, or Shift, or any combination of these keys. Each key is represented by one or more characters, such as a
for the character a, or {ENTER}
for the Enter key.
Enter Vba Code In Excel
To specify characters that aren't displayed when you press the corresponding key (for example: Enter or Tab), use the codes listed in the following table. Each code in the table represents one key on the keyboard. Best movies free download.
Key | Code |
---|---|
BACKSPACE | {BACKSPACE} or {BS} |
BREAK | {BREAK} |
CAPS LOCK | {CAPSLOCK} |
CLEAR | {CLEAR} |
DELETE or DEL | {DELETE} or {DEL} |
DOWN ARROW | {DOWN} |
END | {END} |
ENTER (numeric keypad) | {ENTER} |
ENTER | ~ (tilde) |
ESC | { ESCAPE} or {ESC} |
HELP | {HELP} |
HOME | {HOME} |
INS | {INSERT} |
LEFT ARROW | {LEFT} |
NUM LOCK | {NUMLOCK} |
PAGE DOWN | {PGDN} |
PAGE UP | {PGUP} |
RETURN | {RETURN} |
RIGHT ARROW | {RIGHT} |
SCROLL LOCK | {SCROLLLOCK} |
TAB | {TAB} |
UP ARROW | {UP} |
F1 through F15 | {F1} through {F15} |
Parameters
Name | Required/Optional | Data type | Description |
---|---|---|---|
Key | Required | String | A string indicating the key to be pressed. |
Procedure | Optional | Variant | A string indicating the name of the procedure to be run. If Procedure is ' (empty text), nothing happens when Key is pressed. This form of OnKey changes the normal result of keystrokes in Microsoft Excel. If Procedure is omitted, Key reverts to its normal result in Microsoft Excel, and any special key assignments made with previous OnKey methods are cleared. |
Remarks
The Key argument can specify any single key combined with Alt, Ctrl, or Shift, or any combination of these keys. Each key is represented by one or more characters, such as a
for the character a, or {ENTER}
for the Enter key.
Enter Vba Code In Excel
To specify characters that aren't displayed when you press the corresponding key (for example: Enter or Tab), use the codes listed in the following table. Each code in the table represents one key on the keyboard. Best movies free download.
Key | Code |
---|---|
BACKSPACE | {BACKSPACE} or {BS} |
BREAK | {BREAK} |
CAPS LOCK | {CAPSLOCK} |
CLEAR | {CLEAR} |
DELETE or DEL | {DELETE} or {DEL} |
DOWN ARROW | {DOWN} |
END | {END} |
ENTER (numeric keypad) | {ENTER} |
ENTER | ~ (tilde) |
ESC | { ESCAPE} or {ESC} |
HELP | {HELP} |
HOME | {HOME} |
INS | {INSERT} |
LEFT ARROW | {LEFT} |
NUM LOCK | {NUMLOCK} |
PAGE DOWN | {PGDN} |
PAGE UP | {PGUP} |
RETURN | {RETURN} |
RIGHT ARROW | {RIGHT} |
SCROLL LOCK | {SCROLLLOCK} |
TAB | {TAB} |
UP ARROW | {UP} |
F1 through F15 | {F1} through {F15} |
You can also specify keys combined with Shift and/or Ctrl and/or Alt and/or Command. To specify a key combined with another key or keys, use the following table.
To combine keys with | Precede the key code by |
---|---|
Shift | + (plus sign) |
Ctrl | ^ (caret) |
Alt | % (percent sign) |
Command | * (asterisk) Only applies to Mac; may only work on Excel 2011 for Mac and not later versions. |
To assign a procedure to one of the special characters (+, ^, %, and so on), enclose the character in braces. For details, see the example.
Note
There is no way to currently detect the Command key in recent versions of Office VBA. Microsoft is aware of this and is looking into it.
Example
This example assigns InsertProc to the key sequence Ctrl+Plus Sign, and assigns SpecialPrintProc to the key sequence Shift+Ctrl+Right Arrow.
This example returns Shift+Ctrl+Right Arrow to its normal meaning.
This example disables the Shift+Ctrl+Right Arrow key sequence.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Often we look to certain symbols in Excel that are hard to locate on the keyboard. Or the opposite – we look to find the Excel character codes for certain characters. In such cases we must usually revert to using the CHAR Excel function or the CODE Excel function. Let us explore these functions and how to use them both in Excel and VBA today.
Excel Character Codes
First let us start with exploring the Excel Character codes.
The table below represent the full default encoding in Excel:
On the right side is the Excel character (CHAR) and on the left you have the numeric representation (CODE) of the character. Dl bittorrent.
Converting Characters to Codes (Excel CODE function)
The Excel CODE function allows you to easily obtain the numeric code for the provided character (1 character string).
Syntax
The syntax for the CODE function in VBA is:
Parameters
string
A single character string.
Example usage
Excel
Vba Code For Enter Key In Excel
Below example of using the Excel CODE function:
VBA
Below VBA equivalent of the Excel CODE Funtion – the Asc function
Converting Codes to Characters (Excel CHAR function)
The Excel CHAR function allows you to easily obtain the character represented by the numeric code.
Syntax
The syntax for the CHAR function in Excel is:
Parameters
number
A number from 0-255.
Example usage
Excel
Below example of using the Excel CHAR function:
How To Enter Vba Code In Excel
VBA
Where Do You Enter Vba Code In Excel
Below VBA equivalent of the Excel CHAR Funtion – the Chr function: