PDA

View Full Version : UserForm



IcePirates
01-14-2009, 01:09 PM
Hello,

I have a form Im working on, users fill out the form > submit it, then the data gets displayed on the tab at the bottom called "PartsData"

Problem is, when you open my script, and click the first button to the left that says, "Click here to Add Inventory" - the form wont come up...It was working, I didn't really alter the code any, so Im not sure why it stopped working...

Anyway - was hoping someone might be able to help out!

Thanks! (see attached example)

Im getting an error here
frmParts.Show

But there is nothing wrong with that line...

lucas
01-14-2009, 01:16 PM
Open your workbook and comment the initialize procedure for your userform......

try it again. When it works that tells you that something is wrong with the code in that procedure.......still looking at it.

lucas
01-14-2009, 01:22 PM
cbolocation can't populate because there is no data in column E of sheet lookuplists. I just added data to that column and it worked.

Ischyros
01-14-2009, 05:56 PM
This is where the problem is.....found it moving through your code one line at a time (Shift-F8).


For Each cLoc In ws.Range("LocationList")


I am wondering if data exists in "LocationList"?

Ischyros
01-14-2009, 05:57 PM
Whoops...I see somebody beat me to the punch, lol!