MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formula


Posted by Jackie on January 22, 2002 8:49 AM

Is it possible if my formula is

COUNTIF(A1:A5=65)
to modify the formula in a way that whenever a 65 appears in the column of A to count it without having to go back everytime to the formula and increase the range.

Thanks in advance


Posted by Mark W. on January 22, 2002 8:56 AM

=COUNTIF(A:A,65) (nt)

In the VB editor menue select "Insert" select User Form, then use the toolbox to populate the form with tools. Right click a tool select properties and then build the code. That is what you whant the tool (control) to do, like a button to activate a sheet macro or a checkbox to lode a switch. JSW

Posted by Mark W. on January 22, 2002 8:56 AM

=COUNTIF(A:A,65) [nt]