Thread: [Solved] Add bookmark with vba in the header
View Single Post
 
Old 08-21-2019, 10:29 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
If you are working with a constant string value you can do something like
Code:
Option Explicit
Public Const strText as String = "Student Name"
Sub ShowMe()
  MsgBox "The value is: " & strText
End Sub
Sub ShowMeToo()
  MsgBox "The value is still: " & strText
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote