excel - Loop counter in checkbox name -

-

i trying create sheet have checkbox in each non-empty line. automatically adjust number of checkboxes created macro:

sub checkboxes()  dim integer  = 9 200 set curcell = activesheet.cells(i, 3)     if curcell.value > 1         activesheet.shapes("checkbox" & cstr(i)).visible = true     else         activesheet.shapes("checkbox" & cstr(i)).visible = false     end if     next  end sub

i expect number of potential rows data not greater 200. macro checks if value in column c each line >1, if true checkbox visible, else it's hidden.

my problem don't know how put loop counter "i" shape name - got error using code above. can help?

i think more elegant solution.

this loops through shapes on activesheet , checks if msoolecontrolobject (see here more information on matter). 

sub checkboxes()  dim curcellvalue variant dim long     = 1 activesheet.shapes.count         if activesheet.shapes(i).type = msoolecontrolobject             curcellvalue = activesheet.cells(i, 3).value             if curcellvalue <> ""                 activesheet.shapes(i).visible = true             else                 activesheet.shapes(i).visible = false             end if         end if     next end sub

so why "better"?

  1. you don't have "guess" how many values there be.
  2. if ever change name of checkbox script still working.
  3. this checks empty cells.

also note replaced set curcell = activesheet.cells(i, 3) curcellvalue = activesheet.cells(i, 3).value. don't need set object in every iteration. filling variable suffices.

but: check msoolecontrolobjects includes checkboxes, textboxes , like.

hth.


Comments

Post a Comment

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

-
so when requesting group sequelize follows: return models.workingcalendar .findall({ attributes: [ 'workingcalendar.periodid', 'workingcalendar.date', 'period.name' ], include: [ { model: models.period, attributes: [] } ], where: { getsudoid: currentgetsudo.id, unitplantid: unitplantid }, group: ['workingcalendar.periodid', 'workingcalendar.date', 'period.name'], }); sequelize run query: select [workingcalendar].[id], [workingcalendar].[periodid], [workingcalendar].[date], [period].[name] [workingcalendars] [workingcalendar] left outer join [periods] [period] on [wor...
Read more

delphi - Take screenshot in webcam using VFrames in Console Application -

-
i'm doing program take picture of webcam using delphi xe2 , vframes achieve this, problem have figured out, in graphic application works fine, when use unit in console application, returns me error saying first chance exception @ $76b6b727. exception class eaccessviolation message 'access violation @ address 004a271b in module 'console.exe'. read of address 00000260'. process console.exe (3676) my unit : unit webcam; interface uses sysutils, windows, vcl.imaging.jpeg, vcl.graphics, vsample, vframes, classes; type twebcam = class private procedure newvideoframeevent(sender: tobject; width, height: integer; dataptr: pointer); public constructor create; destructor destroy; override; procedure capture_webcam(take_name: string); end; var web_image: tvideoimage; name_screen: string; implementation constructor twebcam.create; begin inherited create; end; destructor twebcam.destroy; begin inherited destroy; end; ...
Read more

ubuntu - Executors lost when starting pyspark in YARN client mode -

-
i able run pyspark in yarn client mode in laptop , trying setup in laptop. however, time can't running. when try start pyspark in yarn client mode, gives me following error. using dynamic resource allocation, have set spark_executor_memory less yarn container memory. using hadoop 2.6.4, spark 1.6.1, ubuntu 15.10 is possible error due network issues? 16/06/12 01:49:34 info scheduler.dagscheduler: executor lost: 1 (epoch 0) in [1]: 16/06/12 01:49:34 info cluster.yarnclientschedulerbackend: disabling executor 1. 16/06/12 01:49:34 info storage.blockmanagermasterendpoint: trying remove executor 1 blockmanagermaster. 16/06/12 01:49:34 info storage.blockmanagermasterendpoint: removing block manager blockmanagerid(1, 192.168.2.16, 37900) 16/06/12 01:49:34 error client.transportclient: failed send rpc 9123554941984942265 192.168.2.16/192.168.2.16:47630: java.nio.channels.closedchannelexception java.nio.channels.closedchannelexception 16/06/12 01:49:34 info storage.blockmanagermast...
Read more