Text box in excel

[pooja]

Hello everyone !
I inserted one text box in each cell (both row and colomn)for creating a form. I wanted to use the tab function to go from one box to the other in a orderly fashion. But I am not able to do so. The tab jumps randomly through out the form.
Can you help me?????
Thanks.

 

[Legacy 98055]

Hi pooja
Set the tab index properties for each textbox in the order you wish.
In design mode, select a textbox and then view it's properties.
Do this for all...
Tom

 

[pooja]

Hello Ts Tom,
Thank you for the reply.
I could not do the way you suggested cause VBA does not open up. Is there any other way I can work on?
Appreciate your help.

 

[James]

Hi Pooja,

What do you mean by "VBA doesn't open up"
is it locked are you prompted for a password?

James