Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel, cascading combos issue (2000/XP)

    Posted this to other NGs also :
    I've gone over this countless times trying to debug, modify, test..
    and searched for answers on the NGs.

    The combobox (exists on a UserForm) that's causing all the trouble
    is to be filled/updated with numeric data (ZipCodes) where as all the
    other ones are filled with text strings (City,State,Etc). I found this
    code
    on a french language XL forum and have tried to adapt it to my case.

    Long code fragment moved to attachment by HansV

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

    Re: Excel, cascading combos issue (2000/XP)

    Welcome to Woody's Lounge.

    Can you tell us what you want to accomplish, how it relates to the code you posted, and what the problem is?

    Added later: what happens if you change

    ColBaseX.Add Lista(i, Num), Lista(i, Num)

    to

    ColBaseX.Add Lista(i, Num)

    or to

    ColBaseX.Add Lista(i, Num), "C" & Lista(i, Num)

  3. #3
    New Lounger
    Join Date
    Nov 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel, cascading combos issue (2000/XP)

    I apologize. In the future I will attach code instead of pasting directly into posts. I should have thought of it once I figured out that this forum allows attachments.
    I clearly wasn't thinking clearly enough (pun intended), but I guess that's because it is a FORUM and not a newsgroup. There are many benefits to the ability to post
    attachments, and the most important one for me is the ability to explain myself clearly and without all the written text and hyperbole.

    If ... "A Picture is a Thousand Words" Then... "A File is a Thousand Pictures" as long as.... File <> Text

    As for what I was trying to accomplish with this code... I will attach an excel file later, after I finish cleaning it up a bit.
    I was finally able to achieve what I wanted with a workaround. Nothing like a good hack or two!

    Robert

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

    Re: Excel, cascading combos issue (2000/XP)

    Hi Robert,

    No need to apologize, it's understandable. I'm glad you were able to solve the problem.

Posting Permissions

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