Data Form in Excel

[Mavver]

Is it possible to alter the design layout of a basic Data Form in Excel?

I have a a few coloumns that I would like to be a lot larger and few that I would to be smaller.

If there is a way can someone show me a website that explains it.

Thanks in advance for any help

Mav

[Simon Lloyd]

Mav, if its on a worksheet you can simply drag the column wider or smaller, if its on a userform press Alt+F11 to open the VBE and then on the userform right click and choose "View Object" and make your adjustments to which ever you like!

Regards,
Simon

[Mavver]

Hey all,

this has come up again, I thought I had got around it (well ignored it), but I havent

I want to create a data form, not a user form, but when I use the Data - Form function from the tool bar it just creates a one character high text box.

Is it possible to modify the height of the text boxes, since some of the cells have a lot of data in it.

Ta in advance

Mav

[Charlize]

Is it possible to alter the design layout of a basic Data Form in Excel?

I have a a few coloumns that I would like to be a lot larger and few that I would to be smaller.

If there is a way can someone show me a website that explains it.

Thanks in advance for any help

Mav

No, not that I know. But take a look at this link. Maybe you find it usefull : http://www.j-walk.com/ss/dataform/index.htm