+ Reply to Thread
Results 1 to 3 of 3

Change the selection of column data

  1. #1
    Registered User
    Join Date
    12-21-2015
    Location
    Saudi
    MS-Off Ver
    2010
    Posts
    0

    Change the selection of column data

    PLEASE HELP ME TO CHANGE THE COLUMN SELECTION OF MY SEARCH BUTTON TO COLUMN (G:G) OF MY RAW FILE.


    Private Sub cmdBtnSearch_Click()
    Dim i As Long
    Dim sFind As String

    sFind = Me.TextBox11.Text

    If Len(sFind) = 0 Then
    Me.ListBox1.ListIndex = -1
    Me.ListBox1.TopIndex = 0
    Else
    For i = 0 To Me.ListBox1.ListCount - 1
    If InStr(UCase(ListBox1.List(i)), UCase(sFind)) > 0 Then
    Me.ListBox1.TopIndex = i
    Me.ListBox1.ListIndex = i
    Exit For
    End If
    Next i
    End If
    End Sub

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello lemonchibs,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    12-21-2015
    Location
    Saudi
    MS-Off Ver
    2010
    Posts
    0

    Re: Change the selection of column data

    Thanks Mr.arlu for welcoming.

    Please help me to my code to change the column selection of data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change column data based on drop down selection
    By jeremy9400 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-26-2014, 04:58 PM
  2. how to change data in a column based o drop down selection?
    By jeremy9400 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-25-2014, 08:44 PM
  3. [SOLVED] Selection Change event - certain column, certain value
    By D_N_L in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2014, 06:44 AM
  4. Replies: 0
    Last Post: 02-02-2012, 03:16 PM
  5. How to Keep Selection in Column But Change to 2 rows less
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2009, 11:51 PM
  6. Change from Column Selection to Cell Selection
    By Lil Pun in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2006, 06:15 PM
  7. Insert row on change of field - with input selection - not whole column
    By al007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2005, 10:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1