Új hozzászólás Aktív témák

• #24981 Fferi50 Topikgazda KaliJoe #24980

  Új Válasz 2015-01-11 16:13:58 #24981

  Új hozzászólás

  Összes hozzászólása itt Válaszok az összes hozzászólására itt Válaszok erre a hozzászólásra

  Privát üzenet küldése

  

  Fferi50

  Topikgazda

  válasz KaliJoe #24980 üzenetére

  Szia!

  Milyen excel verziód van?
  Igen, sajnos a KeyAscii nem azonos a KeyCode - értékével - ezt valahol írtam is az előbb.

  Ez alapján viszont:
  "
  KeyPress Event

  Occurs when the user presses an ANSI key.

  Syntax

  Private Sub object_KeyPress( ByVal KeyANSI As MSForms.ReturnInteger)

  The KeyPress event syntax has these parts:

  Part Description
  object Required. A valid object.
  KeyANSI Required. An integer value that represents a standard numeric ANSI key code.

  Remarks

  The KeyPress event occurs when the user presses a key that produces a typeable character (an ANSI key) on a running form while the form or a control on it has the focus. The event can occur either before or after the key is released. This event also occurs if you send an ANSI keystroke to a form or control using either the SendKeys action in a macro or the SendKeys Statement in Visual Basic.

  A KeyPress event can occur when any of the following keys are pressed:

  Any printable keyboard character.
  CTRL combined with a character from the standard alphabet.
  CTRL combined with any special character.
  BACKSPACE.
  ESC.

  A KeyPress event does not occur under the following conditions:

  Pressing TAB.
  Pressing ENTER.
  Pressing an arrow key.
  When a keystroke causes the focus to move from one control to another.

  Note
  BACKSPACE is part of the ANSI character set, but DELETE is not. Deleting a character in a control using BACKSPACE causes a KeyPress event; deleting a character using DELETE doesn't.

  When a user holds down a key that produces an ANSI keycode, the KeyDown and KeyPress events alternate repeatedly. When the user releases the key, the KeyUp event occurs. The form or control with the focus receives all keystrokes. A form can have the focus only if it has no controls, or if all its visible controls are disabled.

  The default action for the KeyPress event is to process the event code that corresponds to the key that was pressed. KeyANSI indicates the ANSI character that corresponds to the pressed key or key combination. The KeyPress event interprets the uppercase and lowercase of each character as separate key codes and, therefore, as two separate characters.

  To respond to the physical state of the keyboard, or to handle keystrokes not recognized by the KeyPress event, such as function keys, navigation keys, and any combinations of these with keyboard modifiers (ALT, SHIFT, or CTRL), use the KeyDown and KeyUp event procedures.

  "

  Lehetséges, hogy mégis a KeyPress eseményhez kell menekülnöd, ezt tudja a backspace-t érzékelni.
  A Backspace ansi kódja is 8.

  Próbáld ezt az eseményt úgy, ahogyan az előbb a másikra írtam.

  Üdv.

  Ps:A change esemény kezelésbe most nem mennék bele, mert nincs annyi időm jelenleg. De ígérem, ha egy kicsit szabadulok - visszatérek még rá.

Új hozzászólás Aktív témák