Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 3rd, 2006, 05:20 AM
Registered User
 
Join Date: Jan 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to sime_tyres
Default HOW TO MAKE SEARCHING WITH BEGINNING LETTER

what is the coding for searching. the user only have to key in the beginning letter and the prgm will show all the name with that letter
for example:

after enter the word "P", and click the ok button, the program will show all the name with beginning with "p"

 
Old January 3rd, 2006, 09:37 AM
Friend of Wrox
 
Join Date: Oct 2003
Posts: 168
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

This code will help you

Sub Find()
Dim c As Range
For Each c In Selection
    If c.Value Like "A*" Then
        MsgBox c.Value
    End If
Next
End Sub


-vemaju





Similar Threads
Thread Thread Starter Forum Replies Last Post
How 2 make a searching system rittwick PHP How-To 1 July 4th, 2007 07:58 AM
Generating notification letter Ruman29 Access 1 June 28th, 2006 08:17 PM
search first letter keyvanjan Classic ASP Basics 2 May 17th, 2006 01:47 AM
I have records where I need to replace one letter gilgalbiblewheel Classic ASP Databases 2 March 11th, 2005 02:29 AM
how can i get the drive letter (e.g. F:) of the ne arif_1947 VS.NET 2002/2003 0 October 5th, 2004 12:07 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.