Results 1 to 2 of 2

Thread: VBA code - verification of data for equality
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA code - verification of data for equality

    Dears, I would like to kindly ask you for your advice regards vba code. I need to assure that use right data. As I'm just beginner, not sure how to proceed with that... When push the button, data(text) in column A will be checked for equality. If all the same, run preview before printing. If not, pop up the message window and close macro. Problem will be that no. of rows in column A will change every time...depends of filtered name. I just need to make sure that only 1 name is selected (for further processing of data) Cells in considered / filtered range will be every time checked toward text / data in cell A2 A B C 1 Name 2 John 3 John -----> run preview for printing 4 John 1 Name 2 John 3 John -----> Pop up message box and close running macro 4 William Many thanks for your help in advance Radek
    0 0
     

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,044
    Post Thanks / Like
    Mentioned
    467 Post(s)
    Tagged
    47 Thread(s)

    Default Re: VBA code - verification of data for equality

    Duplicate https://www.mrexcel.com/forum/excel-...st5310791.html

    Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
    Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10
    0 0
     

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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