Posts by Reafidy

  • Chiefs v Brumbies

    Re: Chiefs v Brumbies


    Quote from pike;677132

    Dont think so....and Wallibies to thrash the All Black's


    Bahaha, now I know your talking bollocks... you've lost your marbles. ;)

  • Split text with delimeters

    Re: Split text with delimeters


    MysticGenius,


    The rules are found here, please read them before posting again - see #4.


    You might also want to read the link in my signature regarding crossposting to understand why it is a problem for those offering you free help.

  • Send Variables from A ComboBox to Command Button

    Re: Send Variables from A ComboBox to Command Button


    You can pass variables between procedures by declaring a module level variable or by passing the variable as an argument.


    Code
    Private strMyName As String
Sub DoThis()
    strMyName = "Sam"
End Sub
Sub DoThat
    Msgbox(strMyName)
End Sub


    Or


    Code
    Sub DoThis()
    DoThat("Sam")
End Sub
Sub DoThat(strMyName as String)
    MsgBox("My name is" & strMyName)
End Sub


    But you cant alter the arguments of a click event in the way you were attempting.

  • VBA code to colour a cell on double click

    Re: VBA code to colour a cell on double click


    Something like this:


  • Joke Thread

    Re: Joke Thread


    There's a Kiwi rugby fan, an Australian rugby fan and a beautiful woman sitting next to each other on a train.


    The train enters a tunnel and everything gets dark. Suddenly there is a kissing sound and then a slap! The woman and the Aussie are sitting there looking perplexed. The Aussie is bent over holding his face which is red from an apparent slap.


    The Aussie is thinking, "That bloody kiwi must have tried to kiss this lady, she thought it was me and slapped me."


    The lady was thinking, "That Aussie must have moved to kiss me and kissed the Kiwi instead and got slapped."


    The Kiwi was thinking to himself.... "If this train goes through another tunnel, I could make another kissing sound and slap that damn Aussie in the head again."





  • Joke Thread

    Re: Joke Thread


    Kiwi bloke was on earth doing the Haka. Somewhere in space, Aliens were watching this unusual dance.


    "Kamate, kamate, ka-ora, ka-ora......"


    The Aliens were very interested and they wanted to see what would happen if they would take a part of his brain away without him even knowing. So with their alien technology they sent a laser beam down that hit the Kiwi's head and took a part of his brain away.


    The Aliens then sat back to see what would happen.


    "Ka-mate, ka-mate, ka-ora, ka-ora......."


    What the??? The Aliens were amazed with what they were seeing. The Kiwi guy could operate with less than a full brain. So they decided to send the beam down and take another part of his brain. The Aliens watched on.


    "Ka-mate, ka-mate, ka-ora, ka-ora......"


    "WHAT!!!" the Aliens said to each other. "These Kiwis are very clever people even with half a brain. Let's see what happens if we take the rest of it away and leave him with no brain at all!"


    So with a push of a button the Aliens sent the beam down and took away the final part of the Kiwi's brain.


    "Now surely he won't know anything at all.He should be too dumb and stupid to do anything now?"


    And sure enough, with no brain and no knowledge of anything at all as the Aliens watched on the bloke sang,






    "WALTZING MATILDA, WALTZING MATILDA......"

  • A very hard classifying problem

    Re: A very hard classifying problem


    Flashbond,


    Jindon has requested that the code remain, as the code belongs to him it will do so.


    Also, you may want to remove your email address from earlier posts to prevent spam.