+ Reply to Thread
Results 1 to 4 of 4

msgbox: Show "Hi" when i open excel file based on cell value

  1. 02-17-2017, 09:58 AM #1
    ganeshkumar
    ganeshkumar is offline
    Forum Contributor
    Join Date
    09-07-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    114

    msgbox: Show "Hi" when i open excel file based on cell value

    Hi All,

    i need help in excel macro. i have work book and have two sheets , sheet 1("asd") and sheet 2(bsd")

    in "asd" A3 cell have day for example is A3= "Friday" when i want to show msgbox as "Hi".

    this should run whenever i open file and fir A3 cell is friday.
    Last edited by AliGW; 02-17-2017 at 10:34 AM.
    Reply With QuoteRegister To Reply
  2. 02-17-2017, 11:01 AM #2
    pjwhitfield
    pjwhitfield is offline
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: msgbox: Show "Hi" when i open excel file based on cell value

    well its a good job the answer I supplied in the other thread (having not seen this one) didnt take me long isnt it? seeing as it was deleted mercilessly.....

    In your Workbook_Open event


    Please Login or Register  to view this content.
    Last edited by AliGW; 02-17-2017 at 11:04 AM.
    If someone has helped you then please add to their Reputation
    Reply With QuoteRegister To Reply
  3. 02-17-2017, 11:13 AM #3
    ganeshkumar
    ganeshkumar is offline
    Forum Contributor
    Join Date
    09-07-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    114

    Re: msgbox: Show "Hi" when i open excel file based on cell value

    thanks you so much.. this helps me.
    Reply With QuoteRegister To Reply
  4. 02-17-2017, 11:17 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: msgbox: Show "Hi" when i open excel file based on cell value

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    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. Excel VBA - replace excel msgbox with self msgbox
    By dluhut in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-24-2017, 02:34 PM
  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
    By PinkBanana in forum Excel General
    Replies: 7
    Last Post: 08-20-2010, 03:03 PM
  5. MsgBox
    By braydon16 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-02-2010, 05:54 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] MsgBox-at the end a msgBox popup
    By CC in forum Excel General
    Replies: 4
    Last Post: 05-05-2006, 12: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1