Results 1 to 10 of 15

Thread: Change Data Validation List Based On Value In Cell

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-22-2013, 08:29 AM #14
    jeff
    jeff is offline
    Senior Member
    Join Date
    Jul 2013
    Posts
    102
    Rep Power
    13
    Ingolf

    It allows me to use those names in any order or multiple times......

    I have changed Reg`s name to Steve....it gives a error in code.....i can fix this error by changing the name in the Name Manager and sheet "Lists" which fixes the problem....is it possible to give a Messagebox warning saying the name needs changing in the Name Manager and sheet "Lists" instead of bringing up a error
    Or maybe there is another solution
    Regards

    Jeff
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Data Validation With Dynamic List Of Sheet Names
    By TomyLee in forum Excel Help
    Replies: 2
    Last Post: 08-19-2013, 02:40 AM
  2. Use Combobox List Instead Of Data Validation Dropdown List
    By regc in forum Excel Help
    Replies: 2
    Last Post: 07-28-2013, 09:29 AM
  3. Drop Down List Or Data Validation List To Insert Text In To Cell Range
    By regc in forum Excel Help
    Replies: 4
    Last Post: 07-27-2013, 01:34 PM
  4. How To Lock Or Protect Cell Using Data Validation
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-06-2013, 01:57 AM
  5. Change chart source based on selection in form control list box in excel
    By naveen_itm in forum Excel Help
    Replies: 1
    Last Post: 05-03-2013, 04:41 PM

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
  •  

Forum Rules