My userform was comming up in Excel and entering data properly when the dta
was typed in the combo box. I then tried to enter the code in to fill in the
options in the drop down menus. Now I can't even open the form!

The code when you click on the button to open the form hasn't changed:
Private Sub cmdBringUpForm_Click()
UserForm1.Show
End Sub

So why am I now getting Run-time error '1004' Method 'Range'of
object'_worksheet' failed ??

I did have to insert a new worksheet into the Excel document that contained
the lists of options... could this have affected the opening of the form and
if so how do I correct it?

The help is greatly appreciated! :-)