Question for Excel Experts!!

[tv9_rohith]

I have created form in excel

with text box and the command Buttons.

and now I want to activate the tab key for this so that after entering the data in Text box and click on Tab Button on Keyboard then the command button should get select and then when I click on the enter button then the Query should execute.

It nothing but ignore mouse clicks we should be able to navigate from text box to command button with keyboard.

Thanks,

 

[mikerickson]

What does happen when you press Tab in the text box. If the .TabKeyBehaviour is False, focus should pass to the next control in the tab order.

Also, if the .Default property of a Command Button is True, then pressing Return should activate that command button's click event.

Putting this in the Intialize event should set all that up for the userform.

Private Sub UserForm_Initialize()
    TextBox1.TabIndex = 0
    TextBox1.TabKeyBehavior = False
    CommandButton1.TabIndex = 1
    CommandButton1.Default = True
End Sub

 

[tv9_rohith]

sorry to say that but I am not able to see any result.

My excel is as below :

in sheet 1 I hve 1 Text box to enter the values and then command button to excute and textbox 2 for displaying result and one more command button for clear the values.

if possible could you please tell manual steps on how to do that