data form to browse & edit, with multiline textbox

**SarahMcM** · 12-24-2006, 02:24 AM

Happy Christmas Eve!
This is my first post to this forum and may be a terribly naive question, but here y'go...
I'm using Excel 2003 to develop an very simple Excel 2002 application: I need a form that is almost EXACTLY like the Excel Data Form with JUST ONE tiny change: I would like to make one of the text boxes MULTILINE.

I figure that if I can get to the vba behind the Data Form, I can copy and modify easily enough. But how, how, how do I get to the vba for the Excel Data Form so I can tweak it? Shall I just buy the code behind the JWalk Enhanced Data Form?

Many thanks

**raypayette** · 12-24-2006, 04:18 AM

Happy holidays (politically correct!)!
Either:
Click on Alt + F11
Click Tools, Macro, Visual Basic Editor
or as I do click View, Toolbars, Visual Basic and you will have a icon that will allow you to go to the VBE directly!

**SarahMcM** · 12-25-2006, 08:56 PM

Thanks Ray,
yep, that's what I figured. Trouble is, the built-in Data Form seems to be Modal, so clicking Alt-F11 when it's open does exactly nothing :-( And when the Data Form is not open, I can browse all the VBA code I like: but either i wrote it (so that's going to teach me nothing) or it's password protected (Funcres.xla) All a bit catch-22 for me!

Cheers
Sarah McM

**SarahMcM** · 12-26-2006, 02:25 AM

I've just found reference to SOME ability to customise the Data Form:
here

**raypayette** · 12-26-2006, 12:33 PM

If you want to edit the VBA code while there is an active UDF, make the form non modal ShowModal = False, then use this basic code:
http://www.cpearson.com/excel/vbe.htm

**Gabor** · 12-26-2006, 01:10 PM

Sarah, Ray,

The built-in UserForm is not editable. Or am I wrong?

Sarah,
if you are persuing this task further, please build up your own UserForm (UF) in VBE and I will provide you with some hints how to make it work like the one that is built into Excel.
It is important though to have a ScrollBar1, a SpinButton1, four CommandButtons and a label that is renamed to 'Lab1' (will act as '# of #s' label)
Post a reply if you are ready to continue.

Cheers,
Gabor