Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wv1
  • Content: Threads
  • Order by date
  1. wv1

    User form

    Hi All i have created a userform that contains a list box. This list box builds a UNIQUE list of values from a column- it does so by looping though each row in the column and if it finds a new value it adds it to the list. However, how can I get this list box sorted alphabetically? My code is...
  2. wv1

    Greater than 100%

    Hi All I have a field that calculates a percentage. However i do not want it showing any higher than 100%. Thus if it is calculated at 125% then i simply want to show this result as 100%. How is this best achieved? Thanks again
  3. wv1

    Determine which column is filtered

    Hi All Is it possible to determine which column (1-8) has an autofilter currently ON within it? i.e. If i have columns name, age, school and I have filtered on Column 3 to show only a certain school, is there anyway in a macro that can return to the user which column they currently have a...

Part and Inventory Search

Back
Top