E
ekonomija
Dear,
I have the following issue, so please if someone could help in this one:
Workbook contains differenet dialog boxes with different grades, like
questionaire:
Cell A1: 5
Cell B1: 4
Cell C1: 3
Cell D1: 2
Cell E1: 1
Cells A2:E7 have different check boxes with different text values
How to create a macro:
1. That contains condition: that if check box is filled in the cell
A1, that can't be checked in the other cells in the row, but it is ok for the
other in column.
2. To calculate avarage in the cell E8 of those check boxes: ie. If
from A1:A7 all boxes checked, then avarage is 5,00
p.s. – is it possible to change font type in check boxes? And how?
Thank you very much!
Kindly,
Ekonomija
I have the following issue, so please if someone could help in this one:
Workbook contains differenet dialog boxes with different grades, like
questionaire:
Cell A1: 5
Cell B1: 4
Cell C1: 3
Cell D1: 2
Cell E1: 1
Cells A2:E7 have different check boxes with different text values
How to create a macro:
1. That contains condition: that if check box is filled in the cell
A1, that can't be checked in the other cells in the row, but it is ok for the
other in column.
2. To calculate avarage in the cell E8 of those check boxes: ie. If
from A1:A7 all boxes checked, then avarage is 5,00
p.s. – is it possible to change font type in check boxes? And how?
Thank you very much!
Kindly,
Ekonomija