Excel VBA userform to calculate risk assessment

[wid2001]

I am replicating a risk assessment form in excel. I would like to have a userform for data entry and calculation of values and then print a completed form for signature. I am learning VBA and am making good progress but have a ways to go still. I am not trying to get the form designed and completed by anyone just looking for a way to get started with some of the sections. Of particular concern are the sections where there are three columns and only the highest column total is used. I'm also still trying to work out how, on designated entries they automatically make the overall risk a medium or high regardless of total risk value. I can not decide if I should utilize VBA to calculate everything or maybe create a userform that enters data onto a hidden sheet where it is calculated and then sent to the actual form that gets printed. I am looking to utilize good practices so that when I move to a different position the form can be modified and updated as needed. Hopefully this isn't too cryptic and with the attached pdf original someone will have an idea of what I am attempting to

[Naveed Raza]

Hi Welcome

it would be great if you provide sample workbook with desire output its make very easy analyse the query.

[wid2001]

I have recently learned the etiquette about cross posting and being mindful of others time. I have this posted elsewhere, so in an effort to correct a mistake please consider this thread closed. Thanks