Form Textfields

[ChefSausage]

How can I get a popup textfield that I created in a form (being executed via macro) allow the user to type in multiple lines? No matter how high I make it, I an only type one straight line of text.

 

[xlbo]

set the multiline property of the textbox to true

me.textbox1.multiline = true

HTH Rgds
~Geoff~

 

[ChefSausage]

That's a nice tidbit of knowledge, xlbo. How do I apply that tag when creating an actual userform in the Visual Basic debugger? I physically place the textbox into the grid, but don't know how to access the language properties of that textbox, other than having it output when there is change in the box itself.

 

[xlbo]

visual Basic or Visual Basic for Apps??
If it is the latter, you should be able to bring up the properties window (press F4 in VBE)
This reflects the properties of whatever the selected item is so click on your textbox and scroll down the list of properties. Find multiline and set it to true
HTH Rgds
~Geoff~

 

[ChefSausage]

Another critical element found. Last one, and I can get this work finalized. Once I have the popup textfield and the user is entering data, how do I make the script know when to take the textfield and display the data in the template? If they click return it would only make them go to another line to type.

I know checkboxes use RadioBxName_Click() to display upon mouseclick, but would be used for a textfield?

 

[xlbo]

A command button would do the trick - attach the code to that. User types then presses the command vutton to send the text to the template Rgds
~Geoff~