Code error opening userform for data entry

**dwheggen1** · 03-10-2015, 10:32 AM

First off, relatively new to this site. Thanks for all help.

I am building a file with worksheets for inputting data into a user form and saving the data. I am getting errors trying to open the user form. Been trying to fix for a couple days.

This file was downloaded from contextures and modified.

Thanks again

**jaslake** · 03-10-2015, 02:14 PM

Hi dwheggen1

The Name of the User Form is frmPartLoc.

Please Login or Register  to view this content.

Having said that, you'll get another error...Permission Denied.

You have the Row Source Property of cboPart set and the Code is using the Add Item Method. Can't do that...use one or the other.

You'll get at least a third error when the Code tries to fill cbolocation...your Named Range for ws.Range("LocationList") is empty.