keypress event

Hi all, This might be a basic one, but is it possible to trigger a vba event if cells on a worksheet are cleared? To provide a little context, a have a userform that will drop data into columns B:E starting on row 44. The next entry would be row 45 and so on. I have a macro in place on a shape...

Good day!! I really need help! I made a form on excel 2010 and I included several texboxes with activex, there are no codes on the macro for the texboxes and they work fine except that when I press enter nothing happen, I want the enter key to take me to the next textbox, i've looked on...

Hello All, I have textbox on a Userform that allows the user to enter a dollar amount from 1 to 99,999,999. I was trying to input code into the KeyPress event of the textbox to that while the user is entering an amount, the number is automatically split with commas. This is the code I have...

Greetings all, I put together a routine that handles Key strokes directed to worksheet cells and works in a similar fashion to that of the Keypress event of a TextBox control hence allowing data validation as you type-in among other things. Someone correct me if i am wrong but using the VB...