+ Reply to Thread
Results 1 to 6 of 6

Multiple MSGBOX with manual input

  1. #1
    Forum Contributor
    Join Date
    10-28-2010
    Location
    quebec, canada
    MS-Off Ver
    o365
    Posts
    187

    Multiple MSGBOX with manual input

    Hi guys,

    i never really worked with MSGBOX, and i can't quite figure out the logic in it... but i'd like something fairly simple.

    I am to create a button called "coaching"

    When i click on it, i need to have a series of questions...

    Please enter the date
    (answer will paste in A1)

    Then

    What kind of coaching?
    (paste in A2)

    Enter coaching details;
    (paste in A3)


    if you presses the "coaching" button a second time after doing it the first time, i want it to paste the info in the B column instead of A, if A is not empty, and so on ... so the VBA will always look in A, if full go to B, if full go to C.... Etc

    How complicated is it to do this?

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Multiple MSGBOX with manual input

    Maybe?

    Please Login or Register  to view this content.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,431

    Re: Multiple MSGBOX with manual input

    Very simplistic approach. You need to add whatever testing and looping you need:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Multiple MSGBOX with manual input

    I guess my first question is how much "help" do you need/want?

    I think you might be thinking of InputBox, not msgbox.

    so, create the variables
    assign the values of the Inputbox to the variables.
    determine which is the next column
    write the data...

    do you need help with any/all of these steps?...


    EDIT: what can I say?
    Last edited by judgeh59; 10-27-2014 at 03:52 PM.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,431

    Re: Multiple MSGBOX with manual input

    Thanks for the rep




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

  6. #6
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Multiple MSGBOX with manual input

    Try
    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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. Replies: 12
    Last Post: 04-14-2013, 06:13 PM
  2. [SOLVED] Formula and Manual Input
    By Yidolee in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-18-2013, 01:37 PM
  3. Changing code from Manual input to Calculated input
    By Gertheking in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2012, 11:41 AM
  4. Preventing manual input to a coulumn
    By Momentum in forum Excel General
    Replies: 1
    Last Post: 02-28-2009, 04:10 PM
  5. [SOLVED] Reject Manual Input
    By SMERTZ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2006, 10:30 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