Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo/text box print issue
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo/text box print issue
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo/text box print issue
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo/text box print issue
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo/text box print issue
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo/text box print issue
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
combo/text box print issue
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.... -- Kevin Backmann "Kim K" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formats don't print | Excel Discussion (Misc queries) | |||
Portrait/Landscape print issue | Excel Discussion (Misc queries) | |||
Excel 2003 Print Issue | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Non-Breaking Space + Print Issue | Charts and Charting in Excel |