not necessarily...i did a similar thing with a userform.
If the item wasn't on the list [from a named range] a
button was there which allowed the user to add another
entry...this was then inserted into the named range an therefore
available in the drop down list...
> -----Original Message-----
> From: Richard Gates [SMTP:[log in to unmask]]
> Sent: Tuesday, March 27, 2001 1:18 PM
> To: [log in to unmask]
> Subject: Philosophically, is Excel the right tool?
> As a self employed excel VBA programmer (with no colleagues to talk to), I
> pose the following problem using an analogy of a house:
> My client has an object (the house) which has many components (eg
> bedrooms, kitchens, bathrooms, roofs, garages) of which there may be
> several of the same type (eg 3 bedrooms).
> Each attribute has many types (as many as 30-50). In the analogy there
> may be many types of roof (eg gabled, flat, pitched, tiled, pyramid).
> Each type has several properties (thatched, tiled, concrete, shingled,
> slate, etc.) as well as a rating (eg poor, satisfactory, good,...).
> I need to write a program which lets the user apply a condition rating for
> all points on a very large decision tree in such a way that he doesn't
> miss any relevant points.
> I envision using Excel with a userform A which prompts for all of the
> components (eg number of roofs, bathrooms, studies, etc). A subsequent
> userform B (created from the Userform A data) would show checkboxes for
> each component. If the user clicks roofs, another userform C with 3
> listboxes (or columns) would appear showing the types of roof, the
> materials used, and their condition. The user would select one item from
> Roofs are rather simple. Bedrooms have walls, ceilings, flooring etc
> which must be analysed.
> My problem arises because the lists are not definitive (eg a type of roof
> may be found when using the program which is not in the list eg. stucco,
> alfresco, grass). If I use Excel, and the lists are in columns in the
> workbook, I would expect the user to be able to add new attributes if they
> are not in a list.
> If I were to use VB or Access (of which I am a beginner) I expect I would
> need to write a complex set of routines to add elements to the lists.
> Is Excel the wrong tool to use ????
> Richard Gates (ruminator extraordinaire)
The Information contained in this message is confidential and may be legally
privileged and is intended for the addressee only. If you have received this
message in error or there are any problems please notify the originator
immediately. The unauthorised use, disclosure, copying or alteration of this
message is strictly forbidden. This mail and any attachments have been
scanned for viruses prior to leaving EWS Ltd's network. EWS Ltd will not be
liable for direct, special, indirect or consequential damages arising from
alteration of the contents of this message by a third party or as a result
of any virus being passed on.
For more information about EWS Ltd, please see our website:-