in
All Tags » VBA » list (RSS)

Browse by Tags

  • EASIER DROP DOWN LIST IN VBA

    I built an Excel worksheet using calendar code so that when I click on a cell, the calendar pops up. Works great. Now I want to do the same with people's names. Right now I'm using a drop-down list, so you can scroll through and get someone's name. But folks are finding that annoying because...
    Posted to Miscellaneous (Forum) by microsoft on 04-29-2010

  • How to create a list of sub folders?

    Is it possible to create a list(array) of all the sub folders in a given folder in VBA? for example in the following tree I need to have an array that contains all the sub folders under parts directory. C:\- |__parts__ | |__sub folder 1 | |__sub folder 2 | |__sub folder 3 |__Drawing any kind of help...
    Posted to Access (Forum) by microsoft on 12-10-2009

  • Validation List VBA - Item index?

    Hi, How do I find out the item index of the item selected in a validation list via VBA? Thanks.,
    Posted to Excel (Forum) by microsoft on 08-30-2009

  • Remove Blank Lines in Excel DropDown List

    Good day, I have a drop down box from the control toolbox that gets repopulated depending on the selection of another drop down box. If one of the selections has a lot of items, and the next one you choose has very few...the list box stays the same number of rows in length. This causes a lot of white...
    Posted to Excel (Forum) by microsoft on 08-08-2009

  • VBA in Access: Refreshing a listbox's list

    I'm trying to figure out the best way to refresh data in a dropdown list on a form. The dropdown list contains customers, and the form that the dropdown list is on has a button to click on to open the "edit customers" form. When I click on that button and add a new customer, then close...
    Posted to Access Coding/Macros (Forum) by microsoft on 07-13-2009

  • Outlook VBA: List all subfolders

    Hi All, I would like a macro that works through all the subfolders of a .pst, there are an unknown number of subfolder levels so I can't just use .folders.folders.folders etc...for now let's just say we awnt to msgbox all of the flder names in turn. The following would work for 1 level of sub...
    Posted to Outlook (Forum) by microsoft on 07-09-2009

  • Modify VBA to pass multi-select list to make-table query

    Experts, I have some code that I need to modify but I'm very new to VBA. I'm trying to use this code to read from 2 text boxes (date range), then loop through my multi-select box and pass it to a make-table query. What it's doing is running the entire query without any of my selections. Here's...
    Posted to Access (Forum) by microsoft on 07-04-2009

  • scrolling a list box (in extended multiselect) using VBA code (Not using sendkeys)

    I need to scroll the positioning of the visible portion of an MS Access (2000) form's listbox control at runtime that has its multiselect property set to extended on design but NOT using the conventional setfocus sendkeys approach (I cannot guarantee that the application is the active application...
    Posted to Access (Forum) by microsoft on 07-01-2009

  • VBA Example to list files and folders

    Hello, I am trying to find some completed excel VBA code or a macro that allows me to specify a directory and automatically generates a list in Excel of the folders, subfolders and files - i.e. a full directory tree. I don't wish to use the DOS command for a few reasons. Please can someone advise...
    Posted to Access Coding/Macros (Forum) by microsoft on 06-22-2009

  • Problem: listing files and folders in VBA

    I have a userform which contains two list boxes, ListBox1 and ListBox2. I have found out that the Dir function can list files but I have not yet found any way to list the folders also. My main goal is to load the folders in the first list box and and the second list box to contain the files. i.e. My...
    Posted to Word (Forum) by microsoft on 05-30-2009
Page 1 of 2 (11 items) 1 2 Next >