Complex UserForm for Addding / Amending / Logging / Renewing

Good day All,

Would anyone be able to assist me with my database?

I have got the UserForm to open and populate when I click on a 'risk' within the searchlistbox, however I am having difficulty with the 'reinsurers' listbox where I need to be able to select 1 or many and is separated a line break.

I can populate but I cannot seem to add it onto the table row or when I click amend it just resets the box but doesn't add the changes to the table.

Also, I want to be able to track and forecast changes on 'risks' that are the same... is this possible?
one last thing is the locations - I have them on a separate sheet and I want to create a map - but each table for the location represent a group and I want to be able use the table name for the location and not the individual locations - this is confusing to explain so ignore if I'm not making sense.

I'm sorry if this is a lot to ask but I've been struggling.

thank you.

Hi all, anything I can do or add to assist with my question above?

You can ignore the forecast request. just the initial question would be of much help.

Thank you.

Hi All, still struggling here... if someone can please assist, its beyond me right now

Your workbook won't open here. Not certain if it is just my computer or ???

Should open... i managed to download the one i attached and it opened fine.

Yes 64 bit... I 'commented' out the code that i think is giving issues. See attached?New Testing Database (28122023) (1).xlsb

Any luck from anyone?

Originally Posted by MyForcey

Yes 64 bit... I 'commented' out the code that i think is giving issues. See attached?Attachment 865888

Does this work?

Please may you assist me?