Re: Data validation lists
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
On Jun 21, 9:21 am, shaun collier <shauncoll...@xxxxxxxxxxxxx> wrote:
Hi guys,
Thanks to all that pointed me to data validation...works great. Now I can
use data validation for pull down menus....but I want to put addresses of
customers into a list...so I can use them to invoice quicker...this is easy
if I put the addresses into one cell and use the list. Is it possible to put
addresses into a list in the normal way i.e., as you would write it on an
envelope? Or is there a way so the displayed line is put to rows eg some
sort of delimiter
For example I want to display
123,Abc, etc
As
123
Abc
Etc
Regards
Shaun
The best delimiter to use would be CHAR(13) which is a carriage
return.
If you have names in col G
streets in col H
city, state zip in col I
then put this into col J
=G2&CHAR(13)&H2&CHAR(13)&I2
and make col J the source of the validation list.
When the popup list is seen, the column items are in one line
separated by spaces. But, when line is chosen, it will appear as
separate lines. You will have to format the cell for "wrap text".
Hope this helps.
jpdphd
.
Relevant Pages
- Re: Table design for time periods - advice sought
... >1) Data validation is indeed something done by the user and on that basis ... >alone should be stored in a separate table from Counter events. ... Keen to improve table relationships / DB design ... >>>not there's a list of valid reasons why not. ...
(microsoft.public.access.tablesdbdesign) - Re: Table design for time periods - advice sought
... Data validation is indeed something done by the user and on that basis ... alone should be stored in a separate table from Counter events. ... >>may not relate to the data collection periods and these periods must also ... >>reason for the downtime period is stored in another table ...
(microsoft.public.access.tablesdbdesign) - Re: Calculate if 2 times differ by 24 hours?
... formula to avoid anomalies that arise a result of computer ... I would suggest that you use Data Validation. ... Click on the Error Alert tab, select Show and fill in Style, Title ... Or you could use VBA to display a Msgbox per se. ...
(microsoft.public.excel.programming) - Re: Validations
... >I've completed the first part of an e-commerce web page and need help on ... >data validation of certain fields within the form. ... >noticed irregularities as to how Netscape and IE display items and handle ... >If I were to write validation checks in JavaScript would the output display ...
(comp.lang.java.developer) - Validations
... data validation of certain fields within the form. ... noticed irregularities as to how Netscape and IE display items and handle ... If I were to write validation checks in JavaScript would the output display ... the same for both internet explorer and Netscape? ...
(comp.lang.java.developer) |
|
