Đã hoàn thành

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.

Kĩ năng: Excel, Visual Basic cho Ứng dụng

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Nesna, Norway

ID dự án: #1663902

Được trao cho:


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

$150 USD trong 2 ngày
(61 Đánh Giá)

2 freelancer đang chào giá trung bình $165 cho công việc này


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

$180 USD trong 2 ngày
(0 Nhận xét)