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

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

This is a multi-part message in MIME format.

Content-Type: text/plain;
Content-Transfer-Encoding: quoted-printable

I was wondering the same thing.


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


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

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


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

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at:
* * This email was sent to you via Structural Engineers * Association of Southern California (SEAOSC) server. To * subscribe (no fee) or UnSubscribe, please go to:
* Questions to seaint-ad(--nospam--at) 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: ******* ****** ****** ****** ******* ****** ****** ********