View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Kim K Kim K is offline
external usenet poster
 
Posts: 47
Default combo/text box print issue

That was the culprit! Thanks a bunch!

Now tell me about MS FOrms since I do alot of form design..................
--
Thanks,,
Kim


"Kevin B" wrote:

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.


--
Kevin Backmann


"Kim K" wrote:

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.
--
Thanks,,
Kim


"Kevin B" wrote:

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.
--
Kevin Backmann


"Kim K" wrote:

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....................
--
Thanks,,
Kim


"Kevin B" wrote:

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
--
Kevin Backmann


"Kim K" wrote:

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.
--
Thanks,,
Kim