Read headings from CSV into Form in VBA?

Im using VBA to develop ArcGIS so that I can add added functionality
to it. Dont worry if your not familiar with the software, the
following question is irrelevant to software. Same principle if I was
using MS Word

Think this should be fairly straightforward, I have a few ideas but
would like to bounce them off u lot.

Creating a data entry system for client - nothing fancy:

1. They want to have 4 top heading categories which you can only
choose one of.

2. They then want 5 sub-heading categories (each 5 being different
depending on which top heading was chosen. Multiple sub-headings can
be selected.

3. They want these headings to be changeable - Not often changed, but
perhaps in the future they would like to tweak heading categories.


So, keeping the client out of the VBA code, I thought that perhaps
they could have a simple Excel csv file -

Header1,H1-Sub1,H1-Sub2,H1-Sub3,H1-Sub4,H1-Sub5
Header2,H2-Sub1,H2-Sub2,H2-Sub3,H2-Sub4,H2-Sub5,H2-Sub6
Header3,H3-Sub1,H3-Sub2,,H3-Sub4,
Header4,H4-Sub1,H4-Sub2,H4-Sub3,H4-Sub4,H4-Sub5

Then when in the main project, a form is presented. At the top is a
drop-down - Ive sourced the drop-down items to a text file for now
(new row in txt file is new item) - how would I alter code to read
from the CSV file?

When this drop-down is chosen, it will then read in the corresponding
5 sub choices and update 5 text label/tick box pairs with the correct
headings.

From here, the user will be seeing the correct information to enter
data against.

They choose top level from drop-down. 5 tickbox titles will change
when this happens to show correct categories. User can select multiple
tick-boxes. voila.

So. Is this do-able in VBA? I thought that I might have to split it
into two forms - First a simple tiny form with a drop down pops up -
choose top level, then based on this, will feed variables into the
second form to decide the text boxes. However it would be nice to keep
it all in one form.

Ill leave it at that for now - whadda ya think? Is this bad design,
any better ideas?
.

Relevant Pages

  • Re: Converting a Word doc to a multi-column Excel spreadsheet
    ... I'll post to microsoft.public.word.vba.general and explore Word VBA. ... into a multi-column Excel spreadsheet. ... I think that this processing would predetermine a format style, ... encountered content tagged with a Heading 1 format style, ...
    (microsoft.public.scripting.vbscript)
  • Re: Retrieving Previous Level Number from heading style
    ... from a nominated heading style whether that heading level ... but a Yes or No to include numbering from a previous level. ... The Microsoft advice on equivalent Wordbasic - VBA ...
    (microsoft.public.word.vba.general)
  • Re: Change the range of a pivot table data source
    ... My gameplan is to first import the csv file, then using vba name the ... range of data using the OFFSET function(is there documentation on this and ... The size of the raw data changes so I want to ...
    (microsoft.public.excel.programming)
  • RE: Copy Data to non-office program
    ... be API's that allow your program to directly access the processes of the ... The other program is probably writing your records to a database. ... Best chances are if your other program has the ability to import a CSV file ... I am wondering whether I can do that through VBA. ...
    (microsoft.public.excel.programming)
  • Re: Spool in SQL*Plus without SQL statments
    ... Originally I had it spooling to a text file with my settings and it ... In the midst of trying to accomidate a .csv file, ... set heading on ... spool C:\output.csv ...
    (comp.databases.oracle.misc)
Quantcast