PDA

View Full Version : [SOLVED] Difficulty using KeyPress Command



GabrielAuger
05-09-2016, 08:19 AM
Hi,

I want that the users of my program can only enter numbers and decimal coma (point is changed in coma in my code). But I always get this message when implementin the line: "procedure declaration does not match description of event or procedure having the same name". I tried everything . Thanks in avance.

Please, see the screen shot abd note that my excel is in French (but I code in English).

SamT
05-09-2016, 03:21 PM
Private Sub txtLongueur_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
Also be certain that the control is named exactly "txtLongueur"

GabrielAuger
05-10-2016, 05:15 AM
Thank you very much. It works perfectly.