Results 1 to 6 of 6
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Bug in Application.InputBox function (97, 2000,xp,2003)

    Hi everyone,

    I've just published a new page describing a bug in the Application.Inputbox function (type=8 to get a range):

    http://www.jkp-ads.com/articles/selectarange.asp
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Bug in Application.InputBox function (97, 2000,xp,2003)

    Thanks for the alert and for the workaround!

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bug in Application.InputBox function (97, 2000,xp,2003)

    Yes, Ain't Excel loads of fun!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Bug in Application.InputBox function (97, 2000,xp,2003)

    This is a strange one - why would the presence of conditional formatting with a formula influence Application.InputBox? And why is the RefEdit control programmed differently?

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bug in Application.InputBox function (97, 2000,xp,2003)

    I've been asking the same questions, without coming up with an answer though.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Bug in Application.InputBox function (97, 2000,xp,2003)

    And people actually install software that includes the Registration/Activation Wizard that was programmed by the same folks! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •