Posts by DEEstroyer

    Re: Inputbox not putting info in cell


    I'm not sure if I understand. So should my code look like this:



    But I'm not sure where I'm supposed to put the with part.

    Hi everyone,
    My code is just a bunch of msgbox but at the end I have two InputBoxes. I want the info that is typed in those Inputboxes to be put in the active worksheet but it does not work. How can I execute this. Thanks for the help in advanced.


    My Code


    Thanks Again.

    Hi all,




    Now for the problem. Every time I get to the second msgbox and click either yes or no, it only shows this line in the third msgbox:
    "Wow you are difficult. Now is your chance to go in the opposite direction."


    Any thoughts why? (Sorry if confusing)

    Re: Include Cell Value In MsgBox


    I found out the problem and what I had to do was also reference the workbook so now this is what it looks like,


    [MsgBox "You have" & Workbooks("Personal.xlsb").Sheets("YourSheetNameHere").Range("B1").Value & " days left till your birthday Ryan!"]


    Thank you though for your part.

    Hi. I'm pretty new to Excel VBA and I keep getting this error: Method 'Range' of 'object' Global Failed
    Here's my code and I don't know what is wrong.



    Thanks in advance.