Results 1 to 8 of 8

Button to open file depends on ComboBox Value

Threaded View

puuts Button to open file depends... 03-08-2013, 08:40 AM
hafizimran Re: Button to open file... 03-08-2013, 08:47 AM
puuts Re: Button to open file... 03-08-2013, 09:42 AM
hafizimran Re: Button to open file... 03-08-2013, 12:40 PM
puuts Re: Button to open file... 03-08-2013, 12:54 PM
hafizimran Re: Button to open file... 03-08-2013, 01:35 PM
HaHoBe Re: Button to open file... 03-08-2013, 03:41 PM
puuts Re: Button to open file... 03-08-2013, 09:19 PM
  1. #1
    Forum Contributor
    Join Date
    02-26-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    367

    Button to open file depends on ComboBox Value

    Hello, could you please help me with this.

    I have a Userform with Combobox. What i need is when i pick months in Combobox and hit the button "GO", it will check if the file is available else it will display "Not yet available". When it's available, the file will be open.


    Example path: C:\NEW ADHOCS\January.xlsx, C:\NEW ADHOCS\February.xlsx (this is only available, other months is not)

    When I choose January, it will open January.xlsx
    When I choose February, it will open February.xlsx
    When I choose March or other months, message will pop-up "Not yet Available".

    I have attached the sample file. Thanks in advance.
    Attached Files Attached Files
    Last edited by puuts; 03-08-2013 at 08:46 AM.

Thread Information

Users Browsing this Thread

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

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