Posts by xlite

    I like what Socrates said :)
    Have a great weekend everybody! :dance:
    ---------------------------------------------


    When a man steals your wife, there is no better revenge than to let him
    keep her.
    Sacha Guitry


    After marriage, husband and wife become two sides of a coin; they just
    can't face each other, but still they stay together.
    Hemant Joshi


    By all means marry. If you get a good wife, you'll be happy. If you get a
    bad one, you'll become a philosopher.
    Socrates


    Woman inspires us to great things, and prevents us from achieving them.
    Dumas


    The great question... which I have not been able to answer... is "What does
    a woman want?
    Sigmund Freud


    I had some words with my wife, and she had some paragraphs with me.
    Anonymous


    "Some people ask the secret of our long marriage. We take time to go to a
    restaurant two times a week. A little candlelight, dinner, soft music and
    dancing. She goes Tuesdays, I go Fridays."
    Henry Youngman


    "I don't worry about terrorism. I was married for two years."
    Sam Kinison


    "There's a way of transferring funds that is even faster than electronic
    banking. It's called marriage."
    James Holt McGavran


    "I've had bad luck with both my wives. The first one left me and the
    second one didn't."
    Patrick Murray


    Two secrets to keep your marriage brimming
    1. Whenever you're wrong, admit it,
    2. Whenever you're right, shut up.
    Nash


    The most effective way to remember your wife's birthday is to forget it
    once...
    Anonymous


    You know what I did before I married? Anything I wanted to.
    Henny Youngman


    My wife and I were happy for twenty years. Then we met.
    Rodney Dangerfield


    A good wife always forgives her husband when she's wrong.
    Milton Berle


    Marriage is the only war where one sleeps with the enemy.
    Anonymous


    A man inserted an 'ad' in the classifieds: "Wife wanted".
    Next day he received a hundred letters. They all said the same thing: "You
    can have mine."
    Anonymous

    Re: Disable Mouse


    hi Sahak,


    i've tested this on a simple macro,
    see if it works for you:

    Code
    Application.Interactive = False
    'yr code here
    Application.Interactive = True

    Re: Task Bar Buttons Moving


    hi,


    do you mean the Task Pane is flickering?
    not sure if this will help:

    Code
    Application.ScreenUpdating = False
        Application.CommandBars("Task Pane").Visible = False
        'yr macro here
        Application.CommandBars("Task Pane").Visible = True
        Application.ScreenUpdating = True

    Re: Chart Data Labels


    this code should be easier to understand:


    hope this helps

    Re: Chart Data Labels


    i mod Jon Peltier's code,
    see if it works for u

    Re: Chart Data Labels


    hi oediaz,


    welcome to Ozgrid.com,


    could you explain further?
    what are you trying to achive in general?


    if i'm not wrong, you're trying to tick off/on data labels in a chart?

    Re: Extracting Data To A Text File


    hi,


    you can use this code to convert each sheet into a txt file:


    hope this helps

    Re: Copy & Paste To First Empty Column


    how abt this then:

    Re: Auto Expanding Combo Box


    hi Chris,


    pls see my changes with comments:


    hope it works

    Re: Copy & Paste To First Empty Column


    hi,


    try this out:

    Code
    Sub copyColumn()
    Select Case Sheets("Sheet2").Range("A1") = ""
    Case True 'paste in col A if A1 is empty
    Sheets("Sheet3").Range("A1:A10").Copy Sheets("Sheet2").Range("A1")
    
    
    Case False ' paste to next col
    Sheets("Sheet3").Range("A1:A10").Copy Sheets("Sheet2").Range("IV1").End(xlToLeft).Offset(0, 1)
    End Select
    End Sub


    hope this helps

    Re: Auto Expanding Combo Box


    hmmm, don't really understand the first part of yr sentence,
    but i gues you want to expand the validation list so that you can see the whole text?


    let's say the validation list in in C1,
    put this in yr sheet module:


    hope this helps