Team leader

Andreas Hermle

<div>
Hi Aikimar, thank you very much for your swift and professional response. For me as an amateur in VBA this concise solution looks 'strange' but it seems to work. will do some more testing and then let you know<br />
<br />
Regards, Andreas
</div>


Hi Aikimar, thank you very much for your swift and professional response. For me as an amateur in VBA this concise solution looks 'strange' but it seems to work. will do some more testing and then let you know

Regards, Andreas

<div>
Great job, thank you very much. Will shortly post a similiar question. <br />
<br />
Regards, Andreas
</div>


Great job, thank you very much. Will shortly post a similiar question.

Regards, Andreas

<div>
<div class="content wysiwyg-content">
Dear Experts: <br />
<br />
I got a form with Active X Control boxes. <br />
<br />
In the below code only Range(&quot;F23&quot;) is checked whether it contains the boolean value 'False'.<br />
<br />
I would like to expand the <b>IF statement</b> so that Range &quot;F23&quot; to Range &quot;F30&quot; is included, i.e. the <b>IF statement</b> is true<br />
&nbsp;if any number of Cells (1 to 8) in the range &quot;F23&quot; to &quot;F30&quot; has the boolean value of 'False'.<br />
<br />
Help is very much appreciated. Thank you very much in advance. <br />
<br />
Regards, Andreas<br />
<br />

<pre><code id="code-10-29139526-1">Sub Check_for_value_in_a_range()

If ActiveSheet.OLEObjects(&quot;chbx_GenSurg&quot;).Object.Value = True And ActiveSheet.Range(&quot;F23&quot;).Value = False Then
ActiveSheet.OLEObjects(&quot;chbx_GenSurg&quot;).Object.Value = False

End If

End Sub</code></pre>
</div>
</div>


Dear Experts: 

I got a form with Active X Control boxes. 

In the below code only Range("F23") is checked whether it contains the boolean value 'False'.

I would like to expand the IF statement so that Range "F23" to Range "F30" is included, i.e. the IF statement is true
 if any number of Cells (1 to 8) in the range "F23" to "F30" has the boolean value of 'False'.

Help is very much appreciated. Thank you very much in advance. 

Regards, Andreas

(CODE)

check whether a range of cells contains a certain value using VBA

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.