+ Reply to Thread
Results 1 to 1 of 1

Macro - VBA - to display message based on condition

  1. #1
    Registered User
    Join Date
    09-29-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    27

    Macro - VBA - to display message based on condition

    Hi

    Posted in another forum too
    https://www.mrexcel.com/forum/excel-...condition.html

    I have the attached table. When user press submit button,
    I want to display the following message

    Based on the column C, "Add or Remove":
    Thanks for your license request.
    You have requested to add the following modules:
    Text1, Text3, and Text 4 (Quantity 5), Text 5 (Quantity 5)

    You have requested to remove the following modules:
    Text 4 and Text 6 (Qty-5)

    Your next month bill will increase by $6.00
    (if the bill is reducing i.e. Licence Cost Change is negative then the following message)
    Your next month bill will decrease by $6.00

    Please let me know if you need more information.
    Regards
    Attached Files Attached Files
    Last edited by umeshbanga; 06-16-2019 at 09:13 AM. Reason: Linkback added

+ 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. [SOLVED] Display a message box during If loop condition meets
    By Jimmy1709 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2019, 12:43 AM
  2. [SOLVED] VBA Message box display when cell value is changed, with a condition
    By igormigor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2017, 03:34 AM
  3. [SOLVED] VB Code to instantly display message box if condition is met
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-04-2016, 09:50 PM
  4. [SOLVED] Macro to display rows on separate sheets based on condition
    By phbryan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-19-2016, 11:56 PM
  5. Display a message based on time
    By LisaPatch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2011, 10:11 AM
  6. Display an error message based on particular condition
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-30-2009, 05:53 AM
  7. Display message based on condition
    By Pat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-07-2005, 07:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1