Log In
Register
Home
VBA Code - If DropDown Box = X then equal a specified percentage/number
Ellen Robinson
New Member
Members
Forum Posts: 1
Member Since:
March 21, 2019
March 21, 2019
Offline1
March 21, 2019 - 12:58 am
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!
See Answer
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 929
Purfleet: 415
Hans Hallebeek: 354
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Pamela Malthouse
Lila Huron-Albinger
Harry Maxwell
Jie Liu
Susan Lanham
Dhanushka Rathnayake
Rena Towles
Wim Verhaege
Shavirai Mawere
Macarena Verdugo
Forum Stats:
Groups: 3
Forums: 25
Topics: 7093
Posts: 31099
Member Stats:
Guest Posters: 49
Members: 34526
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —