There is nothing on this line that should cause a problem. Place your cursor
on this line a press F8. This will run your code one line at a time. Keep
pressing F8 until the error message appears. I am guessing that the actual
error might be in a form intialize or form activate event. Give it a try and
let us know how it went...

HTH

"Audrey" wrote:

I've got a macro on a spreadsheet that launches a form but the form wont
open. It has worked for me in the past. I made some minor changes to the
form and the code but now it wont open. When I click on debug here is where
it points...

Sub Button2_Click()
UserForm2.Show this is yellow
End Sub

Any suggestions? I really appreciate your help!!!