excel - Hide Cells Based on Dropdown, Keeps activating when not selected -


i created vba object hide , activate cells based on if particular value selected. contained within first column.

however, whenever continue edit other column once input information hides on me.

the full codes below. it's same thing repeated 5 times over. thanks!

private sub worksheet_change(byval target range)      if target.column = 1 , target.row = 3 , target.value = "cashback"          application.rows("4:7").select          application.selection.entirerow.hidden = false      else          application.rows("4:7").select          application.selection.entirerow.hidden = true      end if                if target.column = 1 , target.row = 3 , target.value = "content"          application.rows("8:25").select          application.selection.entirerow.hidden = false      else          application.rows("8:25").select          application.selection.entirerow.hidden = true      end if        if target.column = 1 , target.row = 3 , target.value = "price comparison"          application.rows("26:40").select          application.selection.entirerow.hidden = false      else          application.rows("26:40").select          application.selection.entirerow.hidden = true      end if            if target.column = 1 , target.row = 3 , target.value = "technology"          application.rows("41:52").select          application.selection.entirerow.hidden = false      else          application.rows("41:52").select          application.selection.entirerow.hidden = true      end if                if target.column = 1 , target.row = 3 , target.value = "vouchers"          application.rows("53:79").select          application.selection.entirerow.hidden = false      else          application.rows("53:79").select          application.selection.entirerow.hidden = true      end if                    if target.column = 1 , target.row = 3 , target.value = "all"          application.rows("3:200").select          application.selection.entirerow.hidden = false      end if                end sub

i refactored code bit make more efficient, easy understand / maintain, and, importantly, meet requirement.

option explicit  private sub worksheet_change(byval target range)  if not intersect(target, me.range("a3")) nothing , target.cells.count = 1      application.screenupdating = false      me.rows("4:200").entirerow.hidden = true      select case target.value          case = "cashback": me.rows("4:7").entirerow.hidden = false         case = "content": me.rows("8:25").entirerow.hidden = false         case = "price comparison": me.rows("26:40").entirerow.hidden = false          '... continue rest of scenarios ...          case = "all": me.rows("4:200").entirerow.hidden = false      end select  end if   end sub

-

Comments

Post a Comment

Popular posts from this blog

cookies - Yii2 Advanced - Share session between frontend and mainsite (duplicate of frontend for www) -

i have custom members system have made: yii2 members system . can refer full details, or install can work question. i have frontend , backend yii2 provides, few modifications separate sessions/cookies backend works admin model , pulls admin table. similar old traditional member systems. mainsite clone of frontend , it's role main website. when go www.site.com or site.com . here 3 apps , example domains: mainsite = www.site.com or site.com frontend = users.site.com backend = admin.site.com when user logs in ( users.site.com/site/login ) , go homepage ( mainsite @ www.site.com ) want know logged in , show username. how frontend operates default advanced app. from have far, login , head mainsite , reads an internal server error occurred. . doesn't yii error, server error? when in yii logs under runtime, mentions access control: 2017-04-14 13:38:25 [127.0.0.1][1][-][error][yii\web\httpexception:403] exception 'yii\web\forbiddenhttpexception'...
Read more

angular - password and confirm password field validation angular2 reactive forms -

i need check whether password , confirm password fields have same value using reactive form angular2. did see lot of answers on same here, angular 2 form validating repeat password , comparing fields in validator angular2 , none seemed work me.can please help."this" undefined in validate function :( . sharing code, this.addedituserform = this.builder.group({ firstname: ['', validators.required], lastname: ['', validators.required], title: ['', validators.required], email: ['', validators.required], password: ['', validators.required], confirmpass: ['', [validators.required, this.validatepasswordconfirmation]] }); validatepasswordconfirmation(group: formgroup): any{ let valid = true; // if (this.addedituserform.controls.password != this.addedituserform.controls.confirmpass) { // valid = false; // this.add...
Read more

php - Permission denied. Laravel linux server -

when try register , send email user got error. working till yesterday. today gives me , cant figure out why. way on local testing work's. i'm stuck. please errorexception in compiled.php line 7512: file_put_contents(/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php): failed open stream: permission denied in compiled.php line 7512 @ handleexceptions->handleerror('2', 'file_put_contents(/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php): failed open stream: permission denied', '/var/www/html/bootstrap/cache/compiled.php', '7512', array('path' => '/var/www/html/storage/framework/views/53de219dee4f11a2db4f64a2c574ad02db5613f4.php', 'contents' => 'please activate account clicking on following link. <a href="<?php echo e(route('auth.activate', $token)); ?>"><?php echo e(route('auth.activate', $token)); ?...
Read more