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



David Adamson wrote:
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




"David Adamson" wrote in message
...
just simply right click on the userform when in development and set
then set the tab order