Results 1 to 3 of 3

Macro to provide list of alternatives based on cell value

Threaded View

  1. #1
    Registered User
    Join Date
    02-15-2011
    Location
    Melbourne Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Macro to provide list of alternatives based on cell value

    Hi,

    I am trying to provide a drop down list of alternatives from another worksheet based on a cell value. I have attached a basic workbook to explain further.
    I have created a form into which a user must enter a postal code. This postal code may have a number of different alternatives:,
    eg: Postal code 4000 may belong to the following areas: Perth,Perth West,South Perth,North Perth.

    What I would like to do is present the user with the 4 alternatives so that they can choose the correct area. I am thinking that I will need a macro to do this. If anyone has any suggestions it would be most welcome.

    Thank you for your help.

    Wayne
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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