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]
You can use the indirect function within a validation list to do the same
thing. To make this work (at least for me) I've found that one needs to use
range names which some people don't like to do.

T. William (Bill) Allen, S.E.
ALLEN DESIGNS
Consulting Structural Engineers

> -----Original Message-----
> From: Dmitri Wright [mailto:dmitri(--nospam--at)cascade-structural.com]
> Sent: Wednesday, December 05, 2007 6:41 AM
> To: Seaint
> Subject: RE: Great ASCE7 spreadsheet
> 
> 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
> ******* ****** ****** ****** ******* ****** ****** ********


******* ****** ******* ******** ******* ******* ******* ***
*   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 
******* ****** ****** ****** ******* ****** ****** ********