+ Reply to Thread
Results 1 to 3 of 3

Get Data from MsgBox into a cell

  1. #1
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2019
    Posts
    756

    Get Data from MsgBox into a cell

    Hello,

    This code works perfectly to scrape data from a website and it shows it via a msgbox:

    Please Login or Register  to view this content.
    However, after testing I would now like the data from my Msgbox to go into a cell on my worksheet. How would I go about doing this?

  2. #2
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Get Data from MsgBox into a cell

    Just store what the message box was passed in variable instead and then set that variable as the value of the range object representing the cell, or skip the variable and use what you passed the msgbox as the value of the range.

    ie:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2019
    Posts
    756

    Re: Get Data from MsgBox into a cell

    Right ok. I have changed it to this, but getting no joy:

    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. [SOLVED] With MsgBox Edit of a cell
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-11-2017, 03:01 AM
  2. Macro to capture MsgBox prompt to a string variable but ignore the MsgBox
    By BuglerDobbs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2015, 10:56 AM
  3. [SOLVED] Problem with VBA Editor uses lower case on some lines (ex. msgbox instead of MsgBox)
    By stubbsj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-14-2013, 06:59 PM
  4. MsgBox on Cell Change
    By longbow007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2010, 08:59 AM
  5. msgbox to appear when cell B5 changes
    By Hein in forum Excel General
    Replies: 2
    Last Post: 04-08-2009, 04:10 AM
  6. MsgBox-center the message on a msgbox
    By CobraLAD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2007, 06:48 AM
  7. Cell Value in a MsgBox
    By PCH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2006, 08:50 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