Making Tabs

[dyowell]

I have designed a form in excel and would like to be able
to set up the form so that when I use the tab key that the
cursor tabs directly to the various fields.

I would also like to be able to make it so that the cells
that have nothing in them are not even available to click
on, and just appear as part of the background of the
form. I am pretty sure that I have seen this done before,
but I do not know how to do it.

Thanks for the help.

 

[David Adamson]

just simply right click on the userform when in development and set then set
the tab order

 

[David Adamson]

Forgot to add.

For the second part
just simply make the cells (textboxes or editboxes ?) that have nothing in
them set the visible to false
Do soemthing like the following when you load the values in

If texbox1.value ="" then
textbox1.visible = false
End if

 

[Damien McBain]

I think he means on a worksheet rather than a userform.