Coding script error-cmd button to open form and for to add new entry to list

Hi All,

I'm working with Excel 97 and have an error in my VB code. I have a sheet (Admin) which contains a button to open a form which is used to add a new entry to a list on another sheet (PriceSchedule). When I try to run the button to open the form, I get an error "Runtime error 9: sub script out of range" or "Runtime error 1004" depending on if I use a ! after the sheet name.

When I run the code for the form (Add_New_Price), the new data to not written to the last row of the PriceSchedule sheet.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Add_New_Price.Show
Add_New_Price.P_Species.SetFocus
End Sub

Also is it posible to use a dropdown list on the form to choose the values "species, grade and market" from validated lists that woulld be the new values that are appended to the new row at the end of the PriceSchedule sheet? If so, how would this be accomplished?

Help in debugging this code would be great appreciated.

Thanks much!

I'm sorry, I split up the code by mistake. The code is as follows:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks again