PDA

View Full Version : Data Form in Excel



Mavver
04-20-2007, 01:45 AM
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
04-20-2007, 02:42 AM
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
06-25-2007, 03:07 AM
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
06-25-2007, 06:47 AM
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

MavNo, 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