Consulting

Results 1 to 2 of 2

Thread: ctrl c and ctrl v breaks a merge cell

  1. #1
    VBAX Newbie
    Joined
    Jun 2008
    Posts
    2
    Location

    ctrl c and ctrl v breaks a merge cell

    Hi,

    I am creating a input form to let users to input something and generate a file.

    I merged few cells that let users to input address.

    But I find one loophole that users can key ctrl c and then ctrl v to break the
    merge cell.

    I have set the name of the merged cell to vAddress such that I get the value
    by this name when generating a file.

    Any one knows how to solve this problem . Thanks in advance.


    eg_ckhad

  2. #2
    Moderator VBAX Guru Simon Lloyd's Avatar
    Joined
    Sep 2005
    Location
    UK
    Posts
    3,003
    Location
    You may well be new here (not at other forums!) but the rules on cross posting are the same as in every forum!

    cross posted here, the thread at the linked location has been locked so you can continue here with your question.
    Regards,
    Simon
    Please read this before cross posting!
    In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
    If I have seen further it is by standing on the shoulders of giants.
    Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)

Posting Permissions

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