UserForm Labels Drawn from Cell in Sheet

This one is driving me crazy, so any help would be very much appreciated.

I have a template that allows the user to create a worksheet for tracking a series of bond investments. When they want to add a new bond, they click a command button that calls a userform (NewBondUserForm) for entering the details of the bond - this then calculates the # of bonds to buy and asks if they'd like to add it to the holdings. If they click yes, it calls a second userform (BondAddUserForm) that asks how many bonds they will actually purchase and then adds them into the holdings.

I'm trying to get this second userform's labels to show the max number of bonds they CAN add as well as the issuer. Both of these data points are held in cells on the activesheet. But no matter what I do the two labels are showing up as blank.

Here's the portion of the code that calls the second userform from within the first:

Please Login or Register  to view this content.

answer = MsgBox("You can purchase up to " & BondNum & " of these Bonds. Add to Ladder?", vbYesNoCancel, "Results")

Select Case answer

Case 7
Unload NewBondUserForm
Exit Sub

Case 6
Call BondAddUserForm_Initialize

Case MsgBoxResult.Cancel
Unload NewBondUserForm
Exit Sub

End Select

Please Login or Register  to view this content.

And then the code for the second userform's initialize, also stored within the first userform's code:

Please Login or Register  to view this content.

Private Sub BondAddUserForm_Initialize()

'***********************Open BondAddUserForm to Finalize Data for Bond Purchase***********************************************

Dim IssuerCap, BondNum As Variant, WS As Worksheet

Set WS = ActiveSheet

IssuerCap = WS.Range("O2")
BondNums = WS.Range("O7")

BondAddUserForm.Show

'Remind user of issuer and suggested purchase number

BondAddUserForm.Label1.Caption = "You are adding a " & IssuerCap & " bond to the ladder"
BondAddUserForm.Label2.Caption = "You can add up to " & BondNum & " bonds to the ladder"

End Sub

Please Login or Register  to view this content.

Thanks in advance for any advice!!!!

Thanks for the input - I used F8 (unaware of that function, super-useful) and cleaned up a bunch of the code on the first userform as a result. I made all the variables I was storing in cells on the activesheet public and still set them via the first userform.

The reason I was using the second userform is twofold: First, the data on the first userform needs to be run through some calculations to recommend a number of bonds to buy (this may be more or less than the target value established earlier in the process depending on the bond price). Second, if the user is targeting, say, $10K in bonds for 2022 maturity, but there are only $5K available to purchase, I need to be able to get that input from the user and adjust the spreadsheet accordingly.

The first userform code ends like this (using .show as you suggest):

Please Login or Register  to view this content.

And then this is the code for the second userform:

Please Login or Register  to view this content.

Still not getting the captions to pop up. All the variables then push through correctly to the calculations that are made when clicking "OK" on the BondAddUserForm. The only issue is the lack of captions showing up on the BondAddUserForm...

Many thanks again.

Awesome! That did it. Thanks so much for the help - been driving me crazy.

-Patrick