How to have dynamic Public Const

I understand that the question sounds silly (Const vs. Dynamic).

Is there any solution for this situation?

Let us say, I have UserformLogin and ModulePublic :

Please Login or Register  to view this content.

If I don't have set temporary value to Username/Password, the ModulePublic cannot compile when opening the workbook.

But the problem is that, I have already used Public Const statement for Username/Password, then in UserformLogin, I am not able to pass textbox value to Username/Password.

How to find an alternative solution?

Thanks.

The reason I would like to put Public Const DatabaseConnectionString As String in ModulePublic is: There are many programs using the string DatabaseConnectionString, so I don't want to repeat the code again and again.