+ Reply to Thread
Results 1 to 4 of 4

Overide the data in list box?

  1. #1
    Registered User
    Join Date
    05-11-2007
    Posts
    93

    Question Overide the data in list box?

    Hi all,

    I have some list boxes in my excel sheet,
    I want to make users to select data from this list dropdown or enter thier own data.

    Right now when user enters other data than ones which are in the dropdown ,excel pops an error.
    I dont want this to happen,

    How can i do this?

    Thank you,
    Glen

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Are you using Data Validation?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    05-11-2007
    Posts
    93
    ya roy, I am using data validation.

    and selecting list option in that.

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    ballack,

    This post has being moved from Programming to Worksheet function. Please read forum rules below.

    Also you may get more responses if you thank people who have helped you in the pass.

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ 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