I've used this method in the past, but for some reason it's not working correctly with a button/form I'm working on.

I have a command button on a worksheet to open a form created in VB. I have always used the command button "click" operation to get to the form. The syntax I've used is:

Load "Form Name"
"Form Name".Show

I keep getting a run-time error '9' Subscript out of range.

Is there a different/better way of accessing this form with a command button?

This is part of a pretty large workbook or I would have attached a copy. I can copy the worksheet and VB to a new workbook if needed.

Thank You