Excel userform

I have an existing unfinished Excel UserForm where I need help to programme.

The userform is going to collect elements for which we want to do a risk assessment.

So the form

1. Collects a sentence with information about what is beeing subject for the risk assesment

2. Displays 4 radio buttons where only one should be chosen (probability)

3. Displays another 4 radio buttons where only one should be chosen (consequence)

4. Calculate these two values to make a "risk"-value.

5. Set a value based on which of these 8 buttons have been clicked in order to decide a color (green, yellow, red)

6. Pass the results to the Excel worksheet. I want one column with the text (what is assesed), one column with the color (make the cell fill color change), one column with the risk value that is calculated.

7. Automatically range the rows in the worksheet on color, and then value, most critical on top.

8. Add a button in the worksheet to allow new entries to be added (load userform)

See the attached file in order to see what I've done.

See worksheet2 in order to see the values and colors that this userform represents.

Compétences : Excel, Visual Basic pour les apps

en voir plus : excel userform, what is a probability, probability help, i need help with excel, excel userform pass button clicked, excel worksheet, need help with excel, need help excel, visual basic form excel, excel visual basic, excel 7, excel visual basic file load, load excel, risk excel, excel file order form, 504, excel cell, basic programme, excel color cell, excel text rows, excel text column, calculate load, excel fill, cell add rows excel, excel add form

Concernant l'employeur :
( 0 commentaires ) Nesna, Norway

Nº du projet : #1663902

Décerné à:


Hello, Excel VBA expert here. Please check PM for details. Thanks!

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(61 Commentaires)

2 freelance font une offre moyenne de $165 pour ce travail


Hi, I have worked on hundreds of similar projects, pick me and I assure you will be pleased

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)