Closed Thread
Results 1 to 2 of 2

need help to change minus value within messagebox on userform

  1. #1
    Forum Contributor
    Join Date
    05-25-2022
    Location
    Asia
    MS-Off Ver
    2016
    Posts
    273

    need help to change minus value within messagebox on userform

    I search for way to correct result in message box

    when show message box I would deal minus amount in textbox1 as plus amount even the real amount is minus in textbox1.

    example :Abed name contains minus value =-2,000.00 when select name from combobox1 and when write in textbox2 =300.00 then will not show message box because I consider minus value as plus value in textbox1 then will not show message box as long amount in textbox1>textbox2 based on message box , the problem will deal minus value in this case will show message box consider textbox1<textbox2 despite of I use Abs function!

    also when select Abdo from combobox1 will populate amount in textbox1=2,000.00 and when write in textbox2 =2,000 then should not show message box because will equal zero , , the problem will show message box showing value is zero.
    so two cases need fixing after change minus value to plus value in textbox1
    1- if textbox> textbox2 then doesn't show message like textbox1=-3000,textbox2=2000 so when change textbox1 to plus when show message box then textbox1=3000 > textbox2= 2000 so no need show message.
    2- if textbox1=textbox2 then doesn't show message like textbox1=-2000 textbox2=2000 when change textbox1 to plus when textbox1=2000 = textbox2= 2000 and 2000-2000=0 so no need show message
    and when there is no minus value in both textboxes like
    1- when there is no minus value for both textboxs but the result will be minus value like
    textbox1=2000, textbox2=3000 so 2000-3000=-1000 will show plus 1000 in message box.
    2- when there is the same value for both textboxes and result=0 then shouldn't show message like textbox1=2000,textbox2=200 so 2000-2000=0
    here is what I try when fill in textbox2 what message should show.
    Please Login or Register  to view this content.
    I'm talking about changing from minus to plus just when show message , don't change in textboxes.
    Attached Files Attached Files
    Last edited by abdo M; 11-24-2024 at 04:21 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,786

    Re: need help to change minus value within messagebox on userform

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #2 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...-userform.html

    Thread closed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] need help to change minus value within messagebox on userform
    By abdo M in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2024, 05:57 AM
  2. [SOLVED] Change messagebox output to only include output for Column WITH a filter.
    By skyping in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-10-2024, 08:04 AM
  3. How to minus textbox1.value from textbox2.value userform
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2017, 07:55 AM
  4. [SOLVED] Change MessageBox to userform message
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2017, 01:31 PM
  5. [SOLVED] MessageBox & Userform
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-03-2015, 04:44 PM
  6. Change row in a Visual Basic messagebox
    By svai in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-11-2006, 01:35 PM
  7. [SOLVED] CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS
    By Socal Analyst looking for help in forum Excel General
    Replies: 2
    Last Post: 05-12-2006, 02:20 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