Show column headings and corresponding values/text based on dropdown selection

[Daph1990]

Thanks @SamT!!!

[SamT]

I haven't forgotten, just been really sore and really busy, which busyness ain't helping the soreness.

[Daph1990]

Oh no...hope it's nothing to serious??

[Daph1990]

Hi Sam, do hope you're feeling better - any luck with a potential fix?

Thank you

[SamT]

Here's what I have so far. Next: Working on the Suppliers Details List box.

[Daph1990]

That's great Sam, look forward to seeing the final bit, the supplier detail part which has been the bane of my life lol!

[Daph1990]

Hi Sam, any indication of when this final part will be completed as I really want testing time...sorry to be a pain but have still been attempting work on it the background but to no avail.

Look forward to hearing back.

Thanks again!

[SamT]

Oops, I need to modify the rest of the code to work t=with the new Supplier details sheet and Form.

One more day. Please!

I hope

[Daph1990]

Okay Sam...thanks!

[SamT]

The code looks like it should work... But there are (at least) two bugs.

Bug one: When selecting a category or sub category, the control shows the next selection, not the one selected. Why don't you work on this. This one is in the various Change Event Subs. It might not even happen in Excel > 2003

Bug two: When The Areas Change Event is triggered to Load the Results (frmSupplierDetails,) Form It Raises a VBIDE Notice that "This will reset your project." I will work on this disturbing bug.

[Daph1990]

Hi Sam,
Thanks for this, not sure if I'm doing something totally wrong here but nothing happens when I press the 'Results' button, is there now another way of generating the results from the selections? As I'm not even able to see Bug 2 because of this.

Bug 1 is happening with my version of excel but it doesn't happen every time, I'm looking this code now,

[Daph1990]

Hi Sam,

Anymore of an update on this as I'm still unable to run the code?

[SamT]

I'm so sorry... My head must be in the right place for Program Engineering and right now, it's full of Mechanical Engineering and Fabrication that I must get done ASAP.

I've gotten this far. The mechanics are working, but the layout and control design need tweaking.

In fact, all the code could be more elegant, but I don't have time for elegance right now.

[Daph1990]

Please, don't be sorry I'm grateful for all the help. I'm just looking through it now, but the mechanics don't quite work in that it still isn't taking any info from the supplier detail sheet it's pretty much the same as it was beforehand which is showing the info from the content sheet only. Is this the right version?

Cheers!

[SamT]

No, that version was just to fix the bug I mentioned before. I'm still working on the Supplier Details Form. I just now found an issue that's driving me buggy. Somehow, the code is skipping a bunch of executions


But only when running normally, Iyt worls fine when stepping thru with F8

Be back later.

[Daph1990]

I'm having some issues when stepping through on F8 but I can work on that. How is the supplier detail part coming along?

[Daph1990]

Is it still awful, and not coming together?

[SamT]

I'm working on what should be the last sub for getting the Supplier Details into an array.

I work on your project most mornings while I am still a bit sane.

[Daph1990]

Hehe I know the feeling. Have you got an estimated time frame of when things should be ready?

[Daph1990]

Hi Sam,

Hope you're well. Sorry to chase again but really keen to know when this will be ready?

Thank you