Inserting Control Toolbox text field in Print function

P

Pablo

Is there a way to print the value of a Control Toolbox text field in a
spreadsheet's header? I have a dynamic print function that prints out the
spreadsheet. I would like to be able to use the text box when the print out
spans multiple pages.


Sub PrintCart()

Dim lngBottomRow As Long
Dim rngData As Range

'Where is the end of the data beginning with row 24, 1-23 reserved for
header
Set rngData = Range("a24").End(xlDown)

lngBottomRow = rngData.Row

Range("A1", "J" & lngBottomRow).PrintOut

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Embedded Text Box 0
Print contents of sub folders 1
Word Macro for multiple searches, incl. in footnotes 2
Variable Range, Control ToolBox ComboBox 3
Finding Hidden text in word VBA 2
Maintaining Text Box Font Setting through VB 4
Print function parsing help 6
type mismatch error in macro in excel 0

Top