Sheet Code Not Updating with userform?

[matrixpom]

Good day all,

I have previously asked this question & was given the solution but since then I have included a UserForm to my WorkBook & now the below issue has returned & now completely gazumped? See below...

I have a sheet code ("Page 3") that based on one cell value ("D10") populates the relevant information from another sheet ("List"), the problem is this value ("D10") is generated from another sheet ("Form") & because of this the code doesn't update? Any help would be greatly appreciated, thank you all & have a great day,

Marco

[mike7952]

I thought PAGE 3 D10 was based on SWMS L1?

[matrixpom]

Hi Mike,

Yes you're right but as previously when a change is made to L1 in SWMS the result changes D10 on Page 3 which in turn should then repopulate the relevant information as found in "List" but for some reason this has stopped working? Thanks for your time Mike - Marco

[matrixpom]

Hi again Mike...my mistake, I had allocated a named range on "List" in column E, this was stuffing up your code, all sorted now, thanks again & have a great day! - Marco

[mike7952]

No problem have a good one.