Initializing a UserForm and Loading Variables with VBA in Excel

Question

I have a userform with an initialize event as follows:

Public CurrSpanNum, CurrSegNum As Integer
Private Sub UserForm_Initialize()

        CurrSegNum = Sheets("UserData").Range("C2").value
        Debug.Print "SegForm, SpanNum = " & CurrSpanNum
        CurrSpanNum = Sheets("UserData").Range("D2").value
        Debug.Print "SegForm, SegNum = " & CurrSegNum

End Sub

In the immediate window I see:

SegForm, SpanNum = 
SegForm, SegNum = 3

The value 3 is placed in both cells before the form is initialized. Why can't I seem to load SpanNum while SegNum is able to load?

panda-34 · Accepted Answer · 2012-06-06 13:25:17Z

4

Well, your CurrSpanNum variable is not initialized and so prints nothing, What would you expect?

answered Jun 6, 2012 at 13:25

panda-34

4,23923 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Initializing a UserForm and Loading Variables with VBA in Excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related