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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.