Posts by trunten

    something like this maybe?



    make sure you try it on a copy first as it's a destructive process. :)

    In Microsoft's ever increasing attempts of sabotage on my previously working code, I've moved to a 64bit machine that completely breaks my above code. I've made an update to the class that should now work regardless. Usage examples remain unchanged.


    Class code:


    As before, class file attached with whitespace prerserved (remove .txt and import into vba)

    my solution

    I think I made changes since the version you downloaded. I've imported the latest userform and it seems ok.


    I've also attached the last version of the combo box I made which has more info about how it all works :)