Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif Code
Hi everyone,
I am trying to promt the user with an input box "What column to count", then use that column to count the number of "Y"s in the column, and return the number in a message box. Here's what I have so far: Sub Count_Yes() Dim Count_Col As Range Set Count_Col = Application.InputBox(prompt:= _ "Select Any Cell in Column to Count", Type:=8) If Count_Col Is Nothing Then Exit Sub End If 'Count Function 'Message Box End Sub Thanks for any help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using countif function in code | Excel Programming | |||
What's the vba code equivalent for Countif | Excel Discussion (Misc queries) | |||
Why does this COUNTIF code not work | Excel Programming | |||
COUNTIF TO BUILD SIMPLE CODE | Excel Worksheet Functions | |||
doing COUNTIF() in code | Excel Programming |