Is it possible to place an integer inside a MsgBox I want to cue the user to add "x" pages of labels before printing this report (labels)... with x referring to the number of pages of the report.
Thanks!
Integer inside a MsgBox? (VBA Access 2000)
Hot Topic
- Password protecting to a command button in Excel?
- Can you tell me why Int(1.4 * 100) = 139
- How do I display my computer name?
- troubleshooting saving versions with macro in Word
- Count and display in cell
- pos peripherals from vba
- Visual Basic for Excel
- Run Time Error 1004 On Long Running Stored Procedure
- Another SendKeys
- Command Buttons (Delete, Run, and Close)
Microsoft ISV
- AutoExec will not execute properly
- [Excel] How to convert Excel to jpg, gif image?
- hidden versus visible in pivot tables
- Customized Scheduler in Outlook 2003 Calendar
- Help with a formula
- Sendkeys to batch file
- Compatibility Issue Excel 2000 and Excel 2003
- MS Access 2003
- Ideas for creating a subset of the string 'pathname' ?
- HELP NEEDED
Integer inside a MsgBox? (VBA Access 2000)
massod
Your probably going to need to convert it to a string
Example
dim i as integer = 1
msgbox("Test Text" & cstr(i))
But as said this is not the forum for VBA questions.
VBA Forums
http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=74&SiteID=1
SMaia
These forums aren't for VBA questions...
But the short answer is yes, you can create a string using a variable something like:
"Be sure to add " & x & " pages of labels before printing."