Results 1 to 10 of 10

Listbox issue + Setfocus after property Issue

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    Dubai
    MS-Off Ver
    Office 365
    Posts
    409

    Listbox issue + Setfocus after property Issue

    Hi Kindly help me solving my issue.

    Please refer attached macro, Its a small Project for a school.

    My issues :

    1. In the Userform1, If we enter a Previously assigned Admission No , it will show as its already assigned to some student which is correct Example Search for S01. but its set focus is lost, I want the set focus to be back on Admission_no

    2. In the Userform3, this is for viewing student history. I am unable to get the filtered data on the list box. which currently managed by copying the filtered data from sheet Student_data to another sheet Payment_ History and then displaying that full data on the listbox LS1. which is not feasible actually because I have another more filters to add-on like.
    Paid and outstanding to show on list box based on search type. (through command buttons Cleared and Outstanding on the userform) - Cleared should show filtered result taking the values of that rows where balance amount(column L) is Zero in the excel, and <>0 for Outstanding.

    so I need filtered data to show on listbox based on filter.

    Pls help me here.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Userform ComboBox Issue - Invalid Property Value
    By Tooley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2016, 12:52 PM
  2. [SOLVED] Run Time Error Issue- Improper Property Value
    By Logit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2016, 08:30 AM
  3. User Form ListBox - Find Records (ListBox Populating Issue)
    By LONeillSSC in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-20-2015, 12:06 PM
  4. Conditional Formatting Issue With the Range Property
    By ankamshetti.nagaraj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2014, 03:57 AM
  5. User Form components' VISIBLE property issue
    By DaveS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2011, 04:53 PM
  6. Form, SetFocus and AfterUpdate issue
    By Piers 2k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2005, 09:55 AM
  7. ShowPivotTableFieldList Property - Version issue/ How to replicate?
    By Alan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2005, 07:06 PM

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