combo/text box print issue

K

Kim K

I created a form with combo and text boxes on it. THe form is perfect except
typed info in the boxes does not print. I am assuming there is something I
need to add to the code or set from false to true, but not sure where to
look, any help appreciated.
 
K

Kevin B

Open the CONTROL TOOLBOX toolbar and click on the DESIGN BUTTON. Right click
on the text box and select PROPERTIES. In the list of available properties
locate LINKED CELL and assign the cell that gets the value entered into the
text box.

Repeat for all textbox or combo box objects
 
K

Kim K

I have located the linked cell option but the text box is overtop of several
cells, it is made to type comments in and text is set to wrap, but the linked
cell option remains blank, do I need to range these cells that fall
underneath the text box? ie the text box is overtop of A30 to
I35....................
 
K

Kevin B

To the best of my knowledge you can only write back to a singe cell at a time
using a textbox object. List boxes and combo boxes can display lists in a
multiple cell range, but they only return a result to a single. cell.

Do you have text boxes for each cell in the range A30 through I35? If
that's the case you might want to consider using Microsoft Forms for your
data entry needs.
 
K

Kim K

I have one text box drawn/expanded over that cell range, thisis a teacher
form done for discipline and that text box was made for comments. THey can
type in the text box, but it fails to print the text in that box when printed.
 
K

Kevin B

Sorry, I believe I misunderstood your question.

To print the text box, open the CONTROL TOOLBOX toolbar, click the design
button and right click on the text box. Select FORMAT CONTROL and then click
on the PROPERTIES tab. Click the check box that says PRINT OBJECT.
 
K

Kim K

That was the culprit! Thanks a bunch!

Now tell me about MS FOrms since I do alot of form design..................
 
K

Kevin B

Microsoft forms are included in all Office products and are availabe in the
VB Editor. Press Alt+F11 to activate the VBE and then click on Insert and
select User Form. You can use the form as an alternative input object, but
you would have to use VBA to program each control and the behavior of the
form.

Once you're in the VBE you can click on HELP in the menu, select MS VISUAL
BASIC HELP and then in the Table of contents click the link for MICROSOFT
VISUAL BASIC REFERENCE and the last topic on the list is MICROSOFT FORMS
VISUAL BASIC REFERENCE. I know that there's a forms community somewhere, but
I don't remember off-hand whether or not it's a Microsoft hosted user group
or not.

Hope this helps....
 
Top