+ Reply to Thread
Results 1 to 3 of 3

Not to focus any row in Listview at first time data loaded.q

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    20

    Not to focus any row in Listview at first time data loaded.q

    HI,

    I wrote a small code to view the data in a listview upon diffrent condition.

    Whenever data is loding to the Listview, the first row has selected automatically.

    I want to select the row only when i clicked any of the rows in the listview.

    My target is: Whenever i selected a row from the listview the "Modify" Button should be activated. Otherewise it should be disabled.

    In my case it is always enable because the first row the listview always selected whenever it loded.

    Can anybody suggest on this?

    Thanks,
    priya
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-24-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2016
    Posts
    124

    Re: Not to focus any row in Listview at first time data loaded.q

    Hi Mate

    I think its either the Setfocus or tabstop parameter.

    Try using (listbox "change this").setfocus = false

    OR

    (listbox "change this").Tabstop.enabled = false

    Might do the trick

    Cheers Dan

  3. #3
    Registered User
    Join Date
    08-22-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Not to focus any row in Listview at first time data loaded.q

    Thanks Dan for quick response...

    I am talking about Listview not Listbox.

    But i tried to change the focus by using SetFocus but it is erroring. (Assognment to constant not set)

    SrchForm_CM.ListView1.SetFocus = False

    And i used Tabstop, but i am not achiving what i want.

    Thanks,
    priya

+ 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. The time now is 1st line and color ListView
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2012, 07:27 PM
  2. Listview checked row delete line in Listview and in worksheet data
    By madforit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2012, 01:00 PM
  3. ListView focus problem
    By Ron1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-07-2010, 07:29 AM
  4. Run Macro after data is loaded
    By erict in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2007, 02:33 PM
  5. [SOLVED] event to know after data has loaded
    By Eric in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2005, 06:06 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