Forum

VBA Code - If DropD...
 
Notifications
Clear all

VBA Code - If DropDown Box = X then equal a specified percentage/number

2 Posts
2 Users
0 Reactions
58 Views
(@ellenrose)
Posts: 1
New Member
Topic starter
 

Hello!

I've spent far to long on this and I know it's a simple solution, but I have to admit, I need help.

Every time a new row is added and when an item is selected from the drop down list, the next column equals a corresponding percent.

e.g. If I select "N STAT"  from drop down, then that = 0%

 

Data

Drop Down List Corresponding Percentage to Equal When List Item is Selected
N STAT 0%
10 CMP 5%
30 CMP 20%
50 CMP 35%
70 CMP 50%
90 CMP 60%
RT 50%
CQ 60%
V OMP 80%
C ENDO 90%
AQ 95%
SMDOI WRK 97%
CRN / APR 100%
RTRD N/A

 

Spreadsheet Example

Document Author Sub Group Status (Drop Down List) Percent
Safety Practice Melissa Smith Safety N STAT 0%
Light Bulb Change Arthur Joy Action 90 CMP 60%
Sweep Floor Jay Jones Action C ENDO 90%
Clean Walls Harry Tan Action CRN / APR 100%

I thank you in advance for you help, it is greatly appreciated!

 
Posted : 21/03/2019 10:58 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Ellen

You can try using Data Validation and VLOOKUP.

See if this help.

Sunny

 
Posted : 21/03/2019 7:04 pm
Share: