Getting runtime error when sub executed through userform change rather than directly

So I developed some code that hides/unhides certain rows based on selections on a userform. I want it to run when a change is made to one of the userform fields that affects what should be visible. The code seems to work great when I execute the macro directly however when I set the userform to call the macro when a change is made to the userform I get an error on the line where it defines the row the selected part number is listed ("PartNumberRow"). The specific error is "Run-time error '1004': Application-defined or object-defined error". What the heck am I missing here. Why would it run just fine when executed directely but not when it is called by a userform change. Thanks for all the help.

Please Login or Register  to view this content.

That shouldn't be possible. The only selectable options are actually pulled from the same 'Test Range'. I do know when I hover over the line in debug mode it is returning a 0 value. Still doesn't make sense why it would find it when executed directly but not when called by a userform change.

I just tried adding your code to trigger the msg box and now "Set rngFnd = Range("Test_Range").Find(What:=PartNumber)" pulls the same error.

When hovering over 'rngFnd' it shows "rngFnd = Nothing" It seems to be having a problem performing the find operation for whatever reason.

I had tried defining the range further by defining the worksheet but it doesn't appear to make a difference. I still get the error.

The "PartNumber" is a text string not a number. This goes for both the worksheet it is searching as well as the selection.

Okay so I still plan on uploading the file for review but I did find a work around.

I changed the trigger of the macro from a change to the userform objects to a change to a "reference" sheet which contains control sources linked to the userform objects. In other words when I change the object in the userform it changes the linked control source cell in the "reference" sheet which then triggers the macro. Still no idea why I can't have the userform object change the trigger the macro without getting an error.

I also found that it is not just an error with that line of code in particular. It appears to have a problem with any range reference, even if I define the workbook and sheet or try to put in code to activate the sheet prior to referencing a range in the sheet.

I should have the file uploaded shortly. I just need to make sure there isn't any sensitive information attached to it. Again thanks for all the help.