excel - Show/hide columns based on input value -


i have 1 input sheet "sheet i", input cell: c3, input value integer, such 1, 2, 3... . output sheets "out 1", "out 2", "out 3", ..."out 10". output sheets contain content a2 g36, while others contain information a2 h36 or t36. ideally, see columns (starting column c) conditionally based on value in $c$3 in sheet i. here logic:

  • if input value = 1, show column a, column b , column c
  • if input value = 2, show column a, column b , column d
  • if input value = 6, show column a, column b , column h
  • .....

right have vba, input value in code set static number. can advise how should change code in order make work? 

private sub workbook_sheetcalculate(byval sh object) dim sharray dim dim myrange, c range  application.screenupdating = false application.enableevents = false sharray = array("out 1", "out 2", "out 3", "out 4", "out 5",.. "out 10") = lbound(sharray) ubound(sharray)     set myrange = sheets(sharray(i)).range("a:t")     each c in myrange         sheets(sharray(i)).rows(c.column).hidden = c.value = "??"     next c next application.enableevents = true application.screenupdating = true end sub

no quite sure if looking should try this. 

if inputvalue = 1 sheets(sharray(i)).columns("a:c").entirecolumn.hidden = false elseif inputvalue = 2  '... elseif inputvalue = 3   end if

Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more