Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    1

    Unanswered: Data Validation and Cut and Paste Problems

    Hey,

    I'm setting up a spreadsheet for data entry, with some columns set to drop-down lists, etc. This works great if every record is manually typed in, but if one is cut and pasted of course the validation goes out the window as the cells are replaced. Is there a way around this? I don't want to disable cut and paste but maybe I could make a macro to emulate this process without ruining the data validation?

    Thanks
    Paul

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Welcome to the board.

    It depends on what you want to have happen. If you PasteSpecial, then the value will be in the cell, but the dropdown still exists. However, the dropdown will not incorporate that new value.

    If you want it incorporated, then it is a much more complicated process. You will need to use a ComboBox (Control Toolbar), and you would need to update by including the new value in the drop down using VBA.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •