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: Mynda Treacy, Bryan Barnett, Lorna Henning
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Tom Lewis
Jennifer Rodriguez-Avila
Forum Stats:
Groups: 3
Forums: 24
Topics: 6542
Posts: 28641
Member Stats:
Guest Posters: 49
Members: 32829
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —