Consulting

Results 1 to 3 of 3

Thread: Solved: Using combobox value in a file path

  1. #1

    Solved: Using combobox value in a file path

    Hi all,

    My aim is to open a folder using a (variable) file path selected using a combobox (in a userform) to select the appropriate file.

    I know this is wrong but this is what I've got so far:
    [vba]FileName:="C:\Documents and Settings\Desktop\Batches\" & UserForm1.ComboBox1 = Value & "0001.emf", _[/vba]

    Do I just have the wrong description or is it much more complicated?

    Thanks

  2. #2
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,094
    Location
    Would need to be
    & UserForm1.ComboBox1.Value

    The form would need to be still open of course.
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  3. #3
    Thanks very much John, worked perfectly

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •