+ Reply to Thread
Results 1 to 2 of 2

Multiple Message Boxes with column title value

  1. #1
    Registered User
    Join Date
    11-29-2016
    Location
    India
    MS-Off Ver
    2010 2007
    Posts
    59

    Multiple Message Boxes with column title value

    Hi,

    I'm looking for a VBA help in User Form. While adding the data from userform to excel sheet, i want message box (with header of the column title) to pop up if cell value does not match my requirement.

    I've 70 columns in a sheet and in Row 1 contains the titles of each colomn, row 2 contains the data entered through Userform & row 3 just for reference with my requirement (either match ISNumber, ISText & Date).

    I need a message box to pop up after adding data if my criteria does not match with the Title on the column in row 1.

    Could any on eplease help me on this.


    Regards,
    Vcare
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-10-2017
    Location
    INDIA
    MS-Off Ver
    365
    Posts
    184

    Re: Multiple Message Boxes with column title value

    Hi,

    I am not very clear with your requirements.

    Do you need a user form to be created to enter data to excel or you already have it???


    And your highlight retirement can be fulfilled with conditional formatting then why you need a macro???

    Check the attached file, if you have the existing records just past them as value don't replace formatting
    Attached Files Attached Files
    Last edited by Sunny18pc; 01-24-2020 at 07:24 AM. Reason: save file
    *If you wish you click on *,a way to say ThankYou

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 versus 2010 VBA message boxes and Dialog boxes look different
    By Melanie Sparr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2019, 10:24 AM
  2. [SOLVED] Return Multiple Column headers from row title and content?
    By loveridge01 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-11-2017, 05:16 AM
  3. Displaying message boxes for multiple emplty cells upon close
    By Capinlarry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2015, 12:52 PM
  4. [SOLVED] Multiple Conditional Message Boxes
    By Pho6 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-31-2014, 05:05 PM
  5. [SOLVED] Multiple message boxes for each locked cell in the same worksheet
    By Justair07 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2013, 04:49 PM
  6. Replies: 2
    Last Post: 07-21-2006, 05:10 AM
  7. Displaying Multiple values with message boxes
    By Dani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2006, 07:45 PM

Tags for this Thread

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