excel - Visual Basic Application -


if me pleased ... wrote code in vba count several things , code must highlight cells in excell color didn't , don't know why ...

here code :

private sub commandbutton1_click()     dim studenti integer     dim prezenti integer     dim absenti integer     dim integer      studenti = activesheet.columns("d").specialcells(xltextvalues).rows.count - 1      prezenti = 0     absenti = 0     = 3 studenti + 2         if (cells(i, 4).value = "a")             absenti = absenti + 1             if (optionbutton2.value = true)                 cells(i, 3).font.color = vbgreen 'rgb(255, 0, 0)             end if         end if          if (cells(i, 4).value = "p")             prezenti = prezenti + 1             if (optionbutton1.value = true)                 cells(i, 3).font.color = rgb(0, 255, 0)             end if         end if          if (optionbutton3.value = true)             cells(i, 3).font.color = rgb(0, 0, 0)         end if     next

the following excel vba code snippet perform core operation, namely: highlighting absenti/presenti (text value "a" or "p" in column d) red/green text color:

private sub commandbutton1_click()     dim studenti integer     dim prezenti integer     dim absenti integer     dim integer      studenti = cells(rows.count, "d").end(xlup).row     = 3 studenti + 2         if (cells(i, 4).value = "a")             cells(i, 4).font.color = rgb(255, 0, 0) 'red         elseif (cells(i, 4).value = "p")             cells(i, 4).font.color = rgb(0, 255, 0) 'green         end if     next end sub

you can modify further purpose adding business logic (all optionbutton.value, counters, etc.).

hope help. best regards


Comments

Post a Comment

Popular posts from this blog

How to access a php class file from PHPFox framework into javascript code written in simple HTML file? -

i've website developed using phpfox v3.0.7 . now i'm trying implement 'sse(server sent events)' 1 of php files. reference i'm giving below necessary code part of file. file titled process.class.php , present @ location /var/www/module/notification/include/service/process.class.php present on server having ip http://34.124.40.142/ . <?php /** * [phpfox_header] */ header('content-type: text/event-stream'); header('cache-control: no-cache'); defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($...
Read more

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more

java - JavaScript + Thymeleaf - select onchange -

i have list of objects services in thymeleaf context, , have following @ page: <select id="inputservice" name="idservice" size="1"> <option th:each="service : ${services}" th:text="${service.name}" th:value="${service.idservice}"/> </select> <p id="selectedservicelimits"></p> each object services contains fields minamount , maxamount . how can print p element these 2 fields of selected service in select javascript? , how can print these 2 fields of option selected when document ready? thanks! <script th:inline="javascript"> /*<![cdata[*/ function showlimits() { var services = /*[[${services}]]*/ null; var selectedindex = $("#inputservice option:selected").index(); var service = services[selectedindex]; $("#amountlimits").text("Ми...
Read more