asked on
Print VBA Srting
Is it possible to print a string with vba? For example:
Dim test As String
test.PrintOut
VBAMicrosoft ExcelVisual Basic.NETVisual Basic ClassicVB Script
Last Comment
Helen Feddema
Print it where?
ASKER
I want to print text to the printer, but I do not want to store the text in any of the worksheets
You could write the text string to a cell, print it out using the Range.Printout method, then delete it:
Public Sub PrintText()
Dim strText As String
Dim rng As Excel.Range
Dim sht As Excel.Worksheet
strText = "Test string"
Set sht = Application.Sheets(1)
sht.Activate
Set rng = sht.Range("A3")
rng.Activate
rng.Value = strText
rng.PrintOut
rng.Value = ""
End Sub
ASKER
I dont want to put the text into the worksheet. Is this impossible?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.