Public Declaration is not public

[USAMax]

I have declared several variables as public but FstCvcCol will not work publicly. Can anyone tell me why?

Public Type myType
    RowColId As Long
    cellStr As String
End Type

Public GlobalArray(100) As myType
Public IndentLevel As Integer                               'Index Level for task Flow worksheet
Public FstSvcCol As Integer                                 'First Service Column for task Flow worksheet

 

[shg]

You haven't posted whatever doesn't work.

The code needs to be in a standard code module, not ThisWorkbook, or a sheet module, or a forms module.

 

[USAMax]

This is posted in a standard module, in fact the module is still named Module4. The strange thing is that all the other Declarations work as they should, only FstSvcCol doesn't work. In this module I set the value to 1 and when I get to the user form the value is empty. I set IndentLevel to one and it passes to two routines in another user form.

 

[shg]

You still have not posted the problematic code.

Have you declared the variable in more than one place? Does Option Explicit appear at the top of every module? (You've spelled the variable two different ways.)

I can make 20 guesses, or you could make it simple.

 

[USAMax]

I know it was a typo here but I could not find a typo in my code. I changed everything from FstSvcCol to FSC and it works. It stands for First Service Column and that would be easy to figure out but I will have to take what works. I used a find and replace to do the work so it wasn't a typo.

Thank you for the effort shg.

 

[shg]

You're welcome.

 

[RoryA]

If that worked it sounds like a duplicate declaration.