+ Reply to Thread
Results 1 to 4 of 4

display collected array data in a MsgBox

  1. #1
    Registered User
    Join Date
    02-04-2014
    Location
    Baltimore, Maryland
    MS-Off Ver
    Excel 2010
    Posts
    17

    display collected array data in a MsgBox

    Two things I need assistance with:

    1. My macro code is having an error message when it comes to storing conditional checked values into my dynamic array
    2. I do not know how to display the collected array data in a msgbox

    Below is what I have so far, any help is appreciated:


    Please Login or Register  to view this content.
    Last edited by UMBiii; 10-21-2014 at 01:23 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,613

    Re: display collected array data in a MsgBox

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

  3. #3
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: display collected array data in a MsgBox

    1. whats the error message?

    2.before the msgbox line

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    02-04-2014
    Location
    Baltimore, Maryland
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: display collected array data in a MsgBox

    Thanks for the assistance, I actually got my code to work. This is the finished code:

    Please Login or Register  to view this content.

+ 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. Display array content in a Msgbox using a loop
    By mortphil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2013, 01:55 AM
  2. Replies: 1
    Last Post: 12-11-2013, 02:55 AM
  3. [SOLVED] Use MsgBox to display the contents of an entire array
    By Dralky in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2013, 10:38 AM
  4. [SOLVED] Listbox column headers when data is collected in an array
    By evertjvr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2012, 09:44 PM
  5. Populate Array then Display in MsgBox
    By additude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2008, 09:01 AM

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