As you stated, you need to put the constant in a module:
Public Constant FORM_TITLE As String = "My Title"
Then, on the Form Load event, place the line:
Me.Caption = FORM_TITLE
or,
Label1.Caption = FORM_TITLE
To change the title for all forms with the caption set to FORM_TITLE, you only need to change the string assigned to the Public Constant 'FORM_TITLE':
FORM_TITLE = "My New Title"
If you want to change the global title name at run time, then do not use a constant, but instead use a public/global variable. Then you can change the string assigned to the variable from anywhere in the program in design mode or at run time.