Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)

---

Knows Key Pressed Large Small Numeric

Online Excel and Excel Macro (VBA) Courses

Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Private Declare Function IsCharAlpha Lib "user32" Alias "IsCharAlphaA" (ByVal cChar As Byte) As Long Private Declare Function IsCharAlphaNumeric Lib "user32" Alias "IsCharAlphaNumericA" (ByVal cChar As Byte) As Long Private Declare Function IsCharLower Lib "user32" Alias "IsCharLowerA" (ByVal cChar As Byte) As Long Private Declare Function IsCharUpper Lib "user32" Alias "IsCharUpperA" (ByVal cChar As Byte) As Long Private Sub UserForm_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Dim strSave As String If IsCharAlphaNumeric(KeyAscii) Then strSave = " Sayısal" If IsCharAlpha(KeyAscii) Then strSave = "Bu karakter" If IsCharLower(KeyAscii) Then strSave = strSave & " Küçük" If IsCharUpper(KeyAscii) Then strSave = strSave & " Büyük" MsgBox "Bastığın tuş: " & Chr$(KeyAscii) & Chr(10) & strSave End Sub

Report problem with this macro

This macro does not work.
There's an error in the code.
Other
You can write your comments about the error in the box below.

Report error

ALL MACROS Youtube Channel
The following macros may be useful for you.

Similar Results

No	Macro Name
1	knows key pressed large small numeric
2	excel operators hk
3	Sends an email to a1
4	know which key is pressed
5	find-delete-change-save codes2
6	Allows textbox and numeric and backspace
7	In the textbox, do not use a comma, and enter 2 points before and after the period.
8	api that finds which key is pressed
9	Color cells by number value within (cells larger than 5 red)
10	enter letters or numbers only
11	textboxa only number
12	Turkish alphabetical sorting also sorts hidden sheet / pages
13	bear automatically recognizing codes
14	Conditional formatting for 9 different values
15	It only enters numbers (0 when the text is entered) in A1 and collects continuously in A1
16	select value in combobox
17	Double-click column 2 to specify the row to add
18	prevent deletion of formulated cells
19	Double-click any cell in column b to specify how many rows to insert
20	type b1e as the number changes in the same cell

---

---

Online Excel Courses

Online Excel Courses are here...

Click to see

Services

• Advanced Excel Courses
• Excel Macro Courses
• Comporate Valuation Courses
• Financial Mathematics
• Financial Modeling
• Comporate Valuation Services

How can we help you?

You can contact us about our services.

Contact us

Subscribe to our Youtube Channel?

Here are the videos that will make your life easier using Excel.

Subscribe Now

Keywords

Excel Videos Advanced Excel Courses Free Macros Free Excel Templates Excel Macro Courses