+ Reply to Thread
Results 1 to 1 of 1

select a item in userform listbox to open a file

Hybrid View

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    zastron,south africa
    MS-Off Ver
    Excel 2010
    Posts
    48

    Question select a item in userform listbox to open a file

    Ha all, how do I select a item in a listbox to open a file?
    The file is located in c:files
    The filename is the same as the selected item in column A
    Then, I have 2 other listboxes, one must show column A of the selection and the other column C.
    Any help will be apriciated
    I have googled but don't find anything usefull for me, the only code I have is:
    LISTBOX1.SELECTED.VALUE = LISTBOX2.VALUE
    Last edited by simeonmein; 10-17-2013 at 09:37 AM. Reason: code
    Creating POS

+ 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. Select listbox item then appear textbox
    By sohaila in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2013, 04:41 AM
  2. [SOLVED] Add Select All item to UserForm ListBox (created by Leth Ross)
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-28-2012, 04:29 AM
  3. [SOLVED] Can one use a Listbox on UserForm without allowing the user to select an item?
    By StevenM in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-26-2012, 05:44 PM
  4. Multi select Listbox Items selection based on other Listbox item selection.
    By srinivassathi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2011, 05:53 AM
  5. ListBox item select default
    By matrixknow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2007, 08:21 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