forms

Andy D 2002 · Apr 30th, 2002, 02:26 AM

hi am using forms (under data menu) for data entry...is there anyway to increase width of text boxes or make data feilds "2 rows high" instead of 1 as makes easier to enter details if adding long descriptions..?
thanks
Andy

jamienwood · Apr 30th, 2002, 02:41 AM

Do you know how to use the forms in VBA, you can design your own form and have the boxes as big as you want.

Colo · Apr 30th, 2002, 03:14 AM

Hi Andy.
As far as I know, you cannot do that with the forms.
Useing Userform is the better way as jamienwood said.

Andy D 2002 · Apr 30th, 2002, 03:18 AM

hi thanks for replies
dont know how to do my own forms - is it fairly straightforward? if so, can u point me in right direction?
thanks
Andy

datastream · Apr 30th, 2002, 04:11 AM

When in excel hit ALT-F11 to start VBA,
goto INSERT and select USERFORMS,
if you dont see your tool box, goto VIEW and select TOOLBOX,
there you can insert boxes and set them to whatever size you want

Audiojoe · Apr 30th, 2002, 04:13 AM

Howdy,

I'll send you a VBA training thing I have. It shows you how to design etc. Make sure you follow the instructions at the beginning to the letter

Audiojoe
Ground control to Major Tom

Apr 30th, 2002, 02:26 AM	#1
Andy D 2002 Board Regular Join Date: Apr 2002 Location: Andy Devine Posts: 106	hi am using forms (under data menu) for data entry...is there anyway to increase width of text boxes or make data feilds "2 rows high" instead of 1 as makes easier to enter details if adding long descriptions..? thanks Andy __________________ Andy Devine

Apr 30th, 2002, 03:14 AM	#3
Colo MrExcel MVP Join Date: Mar 2002 Location: Kobe, Japan Posts: 1,420	Hi Andy. As far as I know, you cannot do that with the forms. Useing Userform is the better way as jamienwood said. __________________ Regards, Masaru Kaji aka Colo - Ex Microsoft MVP Since 2004 -2009

Apr 30th, 2002, 03:18 AM	#4
Andy D 2002 Board Regular Join Date: Apr 2002 Location: Andy Devine Posts: 106	hi thanks for replies dont know how to do my own forms - is it fairly straightforward? if so, can u point me in right direction? thanks Andy __________________ Andy Devine

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 02:41 AM	#2
jamienwood Board Regular Join Date: Apr 2002 Location: Manchester UK Posts: 133	Do you know how to use the forms in VBA, you can design your own form and have the boxes as big as you want.

Apr 30th, 2002, 04:11 AM	#5
datastream New Member Join Date: Apr 2002 Location: Kansas City, MO Posts: 14	When in excel hit ALT-F11 to start VBA, goto INSERT and select USERFORMS, if you dont see your tool box, goto VIEW and select TOOLBOX, there you can insert boxes and set them to whatever size you want

Apr 30th, 2002, 04:13 AM	#6
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Howdy, I'll send you a VBA training thing I have. It shows you how to design etc. Make sure you follow the instructions at the beginning to the letter Audiojoe Ground control to Major Tom