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.

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

    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.

    "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.

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

    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.

    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."

    Re: Disable Mouse

    hi Sahak,

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

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

    Re: Task Bar Buttons Moving


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

    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,

    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


    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


    try this out:

    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