josmarfieror
New Member
- Joined
- Dec 4, 2016
- Messages
- 4
Dear MrExcel,
I want to inquire about merging the input box and printing using VBA Codes. I have a template in printing.
1. I used the Input Box to a certain range to the page will update by using String.
2. If the page I want to print is updated, I need to print the area.
3. Then, I want a dialog box wherein I can abort the printing to check the data first.
I have created a codes below but when I run it. It didn't satisfy the program I want.
Sub GenericInputbox()
Dim SprNum As String
SprNum = Inputbox("Enter the row number")
Range("M10").Value = SprNum
'to print the output
Application.Dialogs(xlDialogPrint).Show
End Sub
Hope you can help me out.
Thanks,
Josmar
I want to inquire about merging the input box and printing using VBA Codes. I have a template in printing.
1. I used the Input Box to a certain range to the page will update by using String.
2. If the page I want to print is updated, I need to print the area.
3. Then, I want a dialog box wherein I can abort the printing to check the data first.
I have created a codes below but when I run it. It didn't satisfy the program I want.
Sub GenericInputbox()
Dim SprNum As String
SprNum = Inputbox("Enter the row number")
Range("M10").Value = SprNum
'to print the output
Application.Dialogs(xlDialogPrint).Show
End Sub
Hope you can help me out.
Thanks,
Josmar