+ Reply to Thread
Results 1 to 7 of 7

MsgBox to display specified ranges values on active row

  1. 10-09-2021, 11:26 AM #1
    MannStewart
    MannStewart is offline
    Forum Contributor
    Join Date
    10-08-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    326

    MsgBox to display specified ranges values on active row

    hi

    i'm just trying to get Excel to display a yes/no MsgBox that includes the values of 5 ranges on the active row, but I don't know what is wrong with my line 4 which Excel is highlighting to debug:

    Please Login or Register  to view this content.

    Can anyone please help ?


    cheers

    Stewart
    Last edited by MannStewart; 10-09-2021 at 11:30 AM.
    Reply With QuoteRegister To Reply
  2. 10-09-2021, 11:32 AM #2
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: MsgBox to display specified ranges values on active row

    What is "this row" referring to ?
    Reply With QuoteRegister To Reply
  3. 10-09-2021, 11:47 AM #3
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,075

    Re: MsgBox to display specified ranges values on active row

    How about 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 10-09-2021, 11:58 AM #4
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: MsgBox to display specified ranges values on active row

    Good code Fluff !
    Reply With QuoteRegister To Reply
  5. 10-09-2021, 01:03 PM #5
    MannStewart
    MannStewart is offline
    Forum Contributor
    Join Date
    10-08-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    326

    Re: MsgBox to display specified ranges values on active row

    @Logit

    sorry typo should have been Arow
    Reply With QuoteRegister To Reply
  6. 10-09-2021, 01:08 PM #6
    MannStewart
    MannStewart is offline
    Forum Contributor
    Join Date
    10-08-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    326

    Re: MsgBox to display specified ranges values on active row

    @Fluff13

    you the guru, many thanks for your help again

    Stewart
    Reply With QuoteRegister To Reply
  7. 10-09-2021, 01:10 PM #7
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,075

    Re: MsgBox to display specified ranges values on active row

    Glad to help & thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Check before exiting SHEET1 if MsgBox is active or not and stop exit if MsgBox is active
    By RIZVI in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-31-2021, 06:56 AM
  2. [SOLVED] Change value and Msgbox display based on two different columns values.
    By thebeastslayer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2020, 10:49 AM
  3. IF formula to display text based on three ranges of values
    By Coenj in forum Excel General
    Replies: 4
    Last Post: 05-17-2019, 12:56 PM
  4. [SOLVED] VBA compare sums in ranges and display delta in MsgBox
    By vio.coman in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-08-2015, 08:37 AM
  5. [SOLVED] VBA compare sums in ranges and display delta in MsgBox
    By vio.coman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2015, 05:15 AM
  6. [SOLVED] Display Range of Values with MsgBox
    By akynyemi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2013, 03:40 AM
  7. How to display specific cells ranges with values greater than 0 on a separate worksheet
    By studentofthegame in forum Excel General
    Replies: 0
    Last Post: 10-08-2012, 05:53 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1