Change Send Keys Default

Arvind1977

Board Regular
Joined
Jul 21, 2006
Messages
108
hi all,

I just Want to change these key from there defalut vlaue to some thing else.. like for ALT# for Shift >


can any one please help
Sendkeys

SHIFT +
CTRL ^
ALT %



Please Help


Regards
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Erdinç E. Karaçam

Board Regular
Joined
Sep 23, 2006
Messages
202
Hi Arvind1977,

Please analysis these sample codes and descriptions.

To Module1's area;


Code:
Sub Auto_Open()
    
    With Application
        .OnKey "^p", ""
        .OnKey "^s", ""
        .OnKey "^c", ""
        .OnKey "^v", ""
        .OnKey "%{F11}", ""
        .OnKey "{F12}", ""
        .OnKey "^x", ""
        .OnKey "^{INSERT}", ""
        .OnKey "+{INSERT}", ""
        .OnKey "{F2}", ""
        .OnKey "{F3}", ""
        .OnKey "{F4}", ""
        .OnKey "{F5}", ""
        .OnKey "{F6}", ""
    End With

End Sub


Code:
Sub Auto_Close()

    With Application
        .OnKey "^p"
        .OnKey "^s"
        .OnKey "^c"
        .OnKey "^v"
        .OnKey "%{F11}"
        .OnKey "{F12}"
        .OnKey "^x"
        .OnKey "^{INSERT}"
        .OnKey "+{INSERT}"
        .OnKey "{F2}"
        .OnKey "{F3}"
        .OnKey "{F4}"
        .OnKey "{F5}"
        .OnKey "{F6}"
    End With
    
End Sub


<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana>Gönderen XL Ver.:</font><font size=1 face=verdana> Office 2003 / </font><font size=1 color=red face=verdana>OS Ver.:</font><font size=1 face=verdana> Windows XP </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>A</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>B</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=yellow nowrap=true><font size=1 color=red face=verdana>Key</font></td><td bgcolor=yellow nowrap=true><font size=1 color=red face=verdana>Code</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BACKSPACE</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{BACKSPACE} or {BS}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BREAK</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{BREAK}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CAPS LOCK</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{CAPSLOCK}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>5</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CLEAR</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{CLEAR}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>6</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>DELETE or DEL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{DELETE} or {DEL}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>7</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>DOWN ARROW</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{DOWN}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>8</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>END</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{END}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>9</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>ENTER (numeric keypad)</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{ENTER}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>10</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>ENTER</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>~ (tilde)</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>11</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>ESC</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{ESCAPE} or {ESC}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>12</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>HELP</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{HELP}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>13</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>HOME</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{HOME}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>14</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>INS</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{INSERT}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>15</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>LEFT ARROW</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{LEFT}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>16</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NUM LOCK</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{NUMLOCK}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>17</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>PAGE DOWN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{PGDN}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>18</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>PAGE UP</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{PGUP}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>19</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>RETURN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{RETURN}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>20</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>RIGHT ARROW</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{RIGHT}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>21</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>SCROLL LOCK</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{SCROLLLOCK}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>22</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>TAB</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{TAB}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>23</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>UP ARROW</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{UP}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>24</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>F1 through F15</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>{F1} through {F15}</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>25</font></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>26</font></td><td bgcolor=yellow nowrap=true><font size=1 color=red face=verdana>To combine keys with</font></td><td bgcolor=yellow nowrap=true><font size=1 color=red face=verdana>Precede the key code by</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>27</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>SHIFT</font></td><td bgcolor=white nowrap=true align=center><font size=1 color=black face=verdana><ACRONYM title='+ (plus sign)'>+ (plus sign) (ƒx)</ACRONYM></font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>28</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CTRL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>^ (caret)</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>29</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>ALT</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>% (percent sign)</font></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana>XLtoHTML v1.1 / ExcelTürkiye - 2006©</font></td></tr></table>
 

Arvind1977

Board Regular
Joined
Jul 21, 2006
Messages
108
Change this sing

Dear Sir,

I Want to Change this

ALT = % (percent sign)


Please help


thanks

arvind verma
 

Watch MrExcel Video

Forum statistics

Threads
1,114,058
Messages
5,545,757
Members
410,704
Latest member
Cobber2008
Top