Search:

Type: Posts; User: Xoolmonster; Keyword(s):

Search: Search took 0.00 seconds.

  1. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    I very much enjoyed talking to you Steve. I sent you a friendsrequest aswell. Hope to have future interesting discussions. I wish you good health for your upcoming new work projects what not!
  2. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    Thats interesting, lots of languages. But from my understanding all languages follow the same logic more or less. You’re a pretty smart guy, accomplished a lot... I do this for my bachelors in...
  3. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    Now i see what you mean, was a bit hard at first to dissect. sort of a more effective way of doing it. what industry are you in since your this familiar with VBA or code in general?
  4. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    thank you Steve for your time and patience. have a good day!
  5. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    Sub UntilHundred()

    Do Until x > 100

    userinput = InputBox("Give a number ")

    Userinput = Val(Userinput)

    x = x + userinput
  6. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    So in this case ´´x = x + userinput´´ stores the inputs given by the user and the program keeps asking the user for a number until the sum on the users inputs are bigger than 100
  7. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    Sub UntilHundred()

    Do Until x > 100

    x = x + userinput

    userinput = InputBox("Give a number ")

    Userinput = Val(Userinput)
  8. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    Sub UntilHundred()

    Do until x > 100

    X = x + userinput

    Message = "Give a number "

    Userinput = InputBox(Message)
  9. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    No wait, 1 should be userinput
  10. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    Sure, from what i understand i should define the variable X as the userinput is that right?
  11. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    Thank you so much Steve. that is very kind of you. I already understand the code and thank you again for your answer. I noticed your message a little late and already built up the following code...
  12. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    IÂ’m sorry to disappoint but I havenÂ’t even started creating it yet. This macro question has been asked in exams before, but thereÂ’s no clear solutions for it in the course material. ItÂ’s supposed...
  13. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    If it was that simple you could just rather type the macro fast instead of writing such a long message
  14. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Re: Vba loop

    I know how and I was just asking for help. I suspected getting a response like this. Thanks a lot 🙏
  15. Thread: Vba loop

    by Xoolmonster
    Replies
    29
    Views
    306

    Vba loop

    Hi guys,

    I need help with a VBA macro that I’m supposed to finish for a course. The instructions for the macro is:

    “Build a macro with a input box within a loop that asks the end user to put in...
Results 1 to 15 of 15