If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > Dependent ComboBox's

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-12-11, 22:08
MatthewM MatthewM is offline
Registered User
 
Join Date: Mar 2007
Posts: 15
Dependent ComboBox's

Hi guys,

I want the functionality within a task manager I am creating that allows me to enter the tasks of a buisness plan.

The buisness plan itself is a simple document, tasks within it are defined within a 3 tier heading layout:

x Tier One headings
x.x Tier Two headings
x.x.x The actual task description itself

I am trying to work out how I can build any 3 tiered document structure in a form based worksheet. For example, I would start by entering my T1 headings, each of which has the capacity to hold any number of T2 subheadings, for which those subheadings can hold any number of tasks.

For veiwing and editing purposes I would like to have two combo boxes that represent T1 and T2 lists. Depending on what is selected in combobox1 the lsit in combobox2 is changed. The correct Heading and sub-heading would be selected in these boxes so that the task manger knows where the task should be recored, or knows which tasks are under those two headings for display purposes.

It also has to be flexible enough to allow the deletion of tasks, subheadings (T2) and headings (T1).

I hope thats understandable,

Matt
Reply With Quote
  #2 (permalink)  
Old 10-13-11, 18:31
MatthewM MatthewM is offline
Registered User
 
Join Date: Mar 2007
Posts: 15
Just a follow up,

I was playing around with Tree view in VB last night and realised they would be far more appropriate than two linked comboboxes.

Plus tree view is also a more intuative way to view the type of structure I am talking about.

Not sure if it can be used in VBA quite as easily but would welcoem any suggestions.

Cheers
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On