+ Reply to Thread
Results 1 to 2 of 2

Case Select....The alternative method for long "Select Case"

  1. #1
    Registered User
    Join Date
    07-16-2008
    Location
    malaysia
    Posts
    6

    Case Select....The alternative method for long "Select Case"

    I've a Worksheet_Change function based on some drop down box changed as follow:

    Please Login or Register  to view this content.
    Let say I have 100 drop down box, e.g. from "$F$1" to "$F$100"

    I tried to create a string that can replace the long target address (e.g. "$F$1", "$F$2", "$F$3",....)

    I've create a code as follow:

    Please Login or Register  to view this content.
    and replace as target address as follow:

    Please Login or Register  to view this content.
    but not working... I'm not sure this method working or not so I'm trying to work on this.

    Could somebody help me on this...

    Thanks!

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    Using your approach try this

    Please Login or Register  to view this content.
    Another way would be

    Please Login or Register  to view this content.
    rylo
    Last edited by rylo; 07-22-2008 at 01:28 AM.

+ Reply to Thread

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