word appears in cell according to another cell changes

[sdhutty]

Hi there,

I currently have a spreadsheet whereby it shows the type of access given to employees for different file locations.

The type of access is shown in column H, they are:

Read
Read/Write
Denied
Access Removed
Pending

These are determined by any 3 people who choose from a drop down menu in the cells from the columns as stated below. There are 4 number options to choose from the drop down menu which correlate to column H:

1 = Read Access
2 = Read/Write
3 = Access Denied
4 = Access Removed

The columns which contain numbers are:

Column I
Column K
Column M
Column O
Column Q
Column S
Column U

So in practice, here's what i want to happen:

If not all three people have selected the same number - then column H turns to 'Pending'.
If 1/3 or 2/3 people have only done their options - then column H turns to 'Pending'.

If all three people have selected '1' from the drop down menu - then column H turns to 'read'.
If all three people have selected '2' from the drop down menu - then column H turns to 'read/write'.
If all three people have selected '3' from the drop down menu - then column H turns to 'Access Denied'.
If all three people have selected '4' from the down down menu - then column H turns to 'Access Removed'.

Any tips on what the vba code is to do this?

Thank you.

 

[mugginsjr]

So there are three users of the same workbook. Is this a shared workbook (set to shared status) on a shared network drive? Or is it just a regular workbook on a shared drive available to all three users? You may need to get the userid of each user to determine which choices he/she has made individually. That's assuming that all three users must select the same option from the dropdown before permission to read or write is granted - I assume.

user = Application.UserName
user = Environ("username")

But I need to know more about your setup. When you say that columns contain numbers, what numbers are they? Employee ID numbers?

 

[sdhutty]

Yes its the same workbook. No its just a regular workbook.

no these numbers are numbers 1-4 as stated above.