+ Reply to Thread
Results 1 to 3 of 3

Novice Needs Help with MsgBox VBA

  1. #1
    Registered User
    Join Date
    10-07-2018
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    12

    Post Novice Needs Help with MsgBox VBA

    Hey all

    I want to create a Macro that when run, displays a line of text in a basic msgbox and also copies the text in a cell on a tab named ?General Data? and then ends on cell A1 on a tab called ?Home?. I?ve tried endless YouTube tutorials but they only give guidance for Windows and I?m using a Mac. Can anyone tell me how to dos this in layman?s terms?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Novice Needs Help with MsgBox VBA

    The code would be the same for Windows or Mac.

    copies the text in a cell
    which cell?

    ends on cell A1
    What do you mean by "ends on"?

    To copy cell A1 from General Data to Home and show a message:
    Please Login or Register  to view this content.
    I can provide more detail if you tell us more about what you need to do.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    09-17-2023
    Location
    Suffolk,UK
    MS-Off Ver
    Home and Office 2019
    Posts
    5

    Re: Novice Needs Help with MsgBox VBA

    Below are example codes lines for you to use and adjust to your needs
    Please Login or Register  to view this content.
    Last edited by 6StringJazzer; 09-17-2023 at 03:36 PM. Reason: added code tags per guideline #2

+ 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] 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] MsgBox containing Data along with password to close the MsgBox
    By quirkybox in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2020, 05:44 AM
  3. [SOLVED] Use some features of MsgBox , but NOT! MsgBox
    By boardy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-11-2020, 12:04 AM
  4. 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
  5. [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
  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. [SOLVED] Novice - MsgBox Yes/No - Continue if Yes, Close if No
    By Beetlejuice in forum Excel General
    Replies: 6
    Last Post: 08-29-2005, 05:05 PM

Tags for this Thread

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