+ Reply to Thread
Results 1 to 4 of 4

Help: Logic for reading/writing cell values based on dual combobox selections

  1. #1
    Registered User
    Join Date
    09-14-2006
    Posts
    7

    Help: Logic for reading/writing cell values based on dual combobox selections

    Hello, I'm fairly new to excel, just getting my feet wet with VB as well.

    I'm trying to do the following with the least amount of code and/or copy/pasting as possible. I'm having trouble figuring out the logic to it.

    The setup:

    I have multiple cells on my presentation page.

    G36 down to G43.
    L36 down to L43.
    Q36 down to Q43.

    Next to these cells I have 2 combo boxes. One is to choose a main category (not dynamic) and the other is to choose a sub category (also not dynamic).

    The main combobox determines which category you choose, and the second combobox breaks that category down. So, for each 10 main categories I have, there are 18 sub-categories.

    I'm allowing the user to write their own notes in the cells I listed above. Each sub-category for each main category will have their own notes.

    Function wise, when a user goes to a different category, the cells will update to the notes they previously wrote.

    I figured I'd have a hidden sheet to store the values, then pull them up depending on which listindexes are selected in the comboboxes. Problem is, I'm not really sure how to efficiently do this. The hidden page's formatting can be whatever (they won't see it).

    How can I do this correctly? Thanks.

  2. #2
    Forum Contributor starryknight64's Avatar
    Join Date
    09-27-2006
    Location
    Missouri
    MS-Off Ver
    2003 (Work) & 2007 (Home)
    Posts
    193
    There really isn't a "correct" way to do this, just "more efficient" ones. You can put the data you want on a seperate sheet, that would make it incedibly easy to change the data on a whim, however, implementing that would be a little trickier (although not a problem).

    Now, before I get on a soap-box about VB code, I highly suggest you Google "Visual Basic tutorial".

    HTH
    starryknight64

  3. #3
    Registered User
    Join Date
    09-14-2006
    Posts
    7
    Don't worry about my VB skills. :D

    I know it well enough to look at it and figure out what's going on as well as write pretty much anything from scratch (most of my programming is done in c# or some c variant). My excel skills are lacking, but I think with some more experimenting I can get a better understanding on how excel works.

    It's just the logic on this type of operation is boggling me. I can't think of a good way to do this. I'd have trouble with it in any language.
    Last edited by MyUserName; 11-02-2006 at 06:57 PM.

  4. #4
    Registered User
    Join Date
    09-14-2006
    Posts
    7
    Bump.

    My brain is melting.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1