View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Check box linked cell = TRUE then J5 valued reduced by 1

Hi Howard,

Am Thu, 12 Mar 2015 23:46:35 -0700 (PDT) schrieb L. Howard:

It came up numbered 22, don't know why as this is a new unused
workbook...? Would have thought it would be 1.


since Decembers patch day the index of ActiveX object starts with 21
But with last Tuesdays patches the index is correct again.

Change the name to
"CheckBox21"
in your code if this CheckBox is the first in the sheet

Regards
Claus B.


Why not "CheckBox1"?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion