Hi
I've declared some public variables as listed below at the start of my project module. Each one is set to a value within a cell on a worksheet and is fixed for the whole project whilst the user is using it and they only change when a new user logs in. However when I try to use them within my project they don't hold the value that I assign to them. Am I using the right syntax?
Thanks
Harv
I've declared some public variables as listed below at the start of my project module. Each one is set to a value within a cell on a worksheet and is fixed for the whole project whilst the user is using it and they only change when a new user logs in. However when I try to use them within my project they don't hold the value that I assign to them. Am I using the right syntax?
Code:
Public pcno, pc_name, division_name As String
Public pcm_name, pcm_username, pcm_email As String
Public od_name, od_username, od_email As String
Public file_name, file_path, status_name As String
Public current_user, authority As String
Public status_value As Integer
Thanks
Harv