Cant load my user form - Subscript out of range

[MCE2014]

Hi,

I keep getting a runtime error 9 - subscript out of range on this one line:

Private Sub btnaddjob_Click()

frmDefects.Show

Dim B1 As Button
B1 = ActiveSheet.Buttons("btnclose")

B1.Font.ColorIndex = 15
B1.Enabled = False

End Sub

There is no misspelling of the name and I have a userform called frmDefects in my collection.

Cannot figure out why it will not accept this simple command

Anyone got any ideas???

 

[Colo]

Hi MCE2014,

I'm sure that posted code doesn't have any problem. A code line in the form frmDefects has an error and it's a runtime error so it occur when the procedure is executed. Please check the cod ein frmDefects.

 

[MCE2014]

Hi MCE2014,

I'm sure that posted code doesn't have any problem. A code line in the form frmDefects has an error and it's a runtime error so it occur when the procedure is executed. Please check the cod ein frmDefects.

Ah I see,

I'm out of office now so I will check frmDefects tomorrow morning for
errors.

Thanks for the reply.