setfocus to command button from Cell

**waelkash** · 07-15-2012, 12:54 AM

Greeting everyone,

I made a simple program to calculate the electric bill. The user has to enter a value in a cell (D6) then he or she should hit enter from the keyboard. Then, he should click on a button, on the same sheet, or hit enter again to get the results in two different cells (D8 an D10).
I'm not using forms or text box.
I looked everywhere for an expression (code) to set the focus to the command button after entering the value in the cell (D6) and hit enter on a keyboard, but I didn't find any thing useful.
I don't have much experience in excel programming, however, I like to learn some of it.
Please give me your valuable advice to win the war.

Regards,

Wael

**Leith Ross** · 07-15-2012, 03:05 AM

Hello Waelkash,

Welcome to the Forum!

The code below assumes the name of the Command Button on the worksheet is "CommandButton1". This code is pasted into the worksheet module that has the command button. Your code that you want to execute when the user clicks or hits return would replace the "Beep" command in the code.

Please Login or Register  to view this content.

**waelkash** · 07-15-2012, 07:59 AM

Thank you Leith

Your codes is working fine

I have two more wondarings.

1. Would you please explain how these codes works

2. I hope it is possible to make the CommandButton1 do the event when pressing enter on the keyboard also. Now it only beeps.

I appreciate your concern.

Have a nice life.

Wael