+ Reply to Thread
Results 1 to 8 of 8

With MsgBox Edit of a cell

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    With MsgBox Edit of a cell

    hi,
    i am populating a msgbox to pritout a file,
    when i click code then a msgbox appears,

    i want to edit a cell with msgbox able


    thanx
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: With MsgBox Edit of a cell

    Come on HaroonSid

    by you you should know that we need more info...Perhaps a sample workbook or a more detailed explanation.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: With MsgBox Edit of a cell

    here is sample
    when i run macro a msgbox appears for asking a print, in that movement i cant edit in my sheets, is it possible to edit?

    Capture.JPG
    Attached Files Attached Files

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: With MsgBox Edit of a cell

    This thread will solve your problem:
    http://stackoverflow.com/questions/3...ge-window-open

  5. #5
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: With MsgBox Edit of a cell

    hi, sintek
    Not able to sort out the problem, will you please help me to sort out the problem

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: With MsgBox Edit of a cell

    Sure...I'll look into it as soon as I am able.

    EDITED:

    I attached a sample using a created userform as I feel that one can have more control....
    Attached Files Attached Files
    Last edited by sintek; 05-11-2017 at 02:01 AM.

  7. #7
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: With MsgBox Edit of a cell

    Yes you did a very good trick

    thank you Sintek

  8. #8
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: With MsgBox Edit of a cell

    Pleasure...Glad i could help. Thanks for rep points.
    And remember......Mark Thread as Solved.

+ 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. 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
  2. [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
  3. Edit code to loop error msgbox and inputbox until valid date is entered by user.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2012, 10:07 PM
  4. Prompting a MsgBox upon row/cell edit
    By kid_epicurus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2012, 03:23 PM
  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