Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Great ASCE7 spreadsheet

[Subject Prev][Subject Next][Thread Prev][Thread Next]
I think the main difference between the combo box and validation list, is that the combo box returns an index number of the list item chosen by the user. This can then be used for data lookup, or easy to write IF-THEN statements. Data validation works great for simple switches like yes/no or seismic/nonseismic, but is less useful for more complicated information. One trick I learned was to always include reference lists for either control type on the same sheet as the control. You can then copy individual sheets to other books without loosing the control links.

Dmitri Wright, PE
Cascade Engineering, Inc.
2459 SE TV Hwy, PMB #202
Hillsboro, OR  97123-7919
dmitri(--nospam--at)cascade-structural.com
503-846-1131



From: "Bill Allen" <t.w.allen(--nospam--at)cox.net>
To: <seaint(--nospam--at)seaint.org>
Subject: RE: Great ASCE7 spreadsheet

This is a multi-part message in MIME format.

------=_NextPart_000_0003_01C836AC.05E556D0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I was wondering the same thing.

=20

T. William (Bill) Allen, S.E.

ALLEN DESIGNS <http://www.AllenDesigns.com>=20

Consulting Structural Engineers
V (949) 248-8588 . F(949) 209-2509

-----Original Message-----
From: Conrad Harrison [mailto:sch.tectonic(--nospam--at)bigpond.com]=20
Sent: Tuesday, December 04, 2007 6:55 PM
To: seaint(--nospam--at)seaint.org
Subject: RE: Great ASCE7 spreadsheet

=20

Curious as to why people use the combobox from the control toolbox, =
rather
than use the simpler data validation list.=20




******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
* * This email was sent to you via Structural Engineers * Association of Southern California (SEAOSC) server. To * subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
* Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you * send to the list is public domain and may be re-posted * without your permission. Make sure you visit our web * site at: http://www.seaint.org ******* ****** ****** ****** ******* ****** ****** ********