hi , i need coding in command button , when i like to click it , an inputbox should appear that ask me to enter the date , then another inputbox appears that ask me to put a string value any from column A , then coding will work and matches the input date with column B and shows the result in msgbox how many times Yes appears in column A or No appears in msgbox .etc
Please Login or Register to view this content.
If solved remember to mark Thread as solved
thanks . that works good
Hi, mubashar,
after collecting the information from the user I would recommend to use WorksheetFunction.CountIf on the ranges instead of looping through them. Besides: you could use wildcards for finding only a part of the cell contents (or use Trim in order to not get tangled with blanks after the expression in the cell).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks