LinkBack URL
About LinkBacks
Hi All
I use data validation list control to populate fields on a form, this works great.
If the customer isn't within the list I wish to add new content and I don't know how to do this?
Can you help me please?
Thanks
Steven811
Hi All
I use data validation list control to populate fields on a form, this works great.
If the customer isn't within the list I wish to add new content and I don't know how to do this?
Can you help me please?
Thanks
Steven811
Select a cell with the data validation. Click on the Data tab, Data Validation. List should be selected and in the source field there is either a list of values separated by commas or there is an equation referring to a list. If and equation, it could refer to a range of cells that contain the values or it could refer to a Defined Name that contains an equation or a range of cells with the values.
If the Source field has a list separated by commas, add the value(s) that you require. If the Source Field has an equation, go to the list referenced by the equation and add the value(s) and then change the cell references in the equation in Data Validation. If the equation refers to a Defined Name, go to the Name Manager, find the name and make the changes to the range in the formula defining the name after adding the value(s) to the list of values for the data validation.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hi newdoverman
The data comes from a list on another worksheet within the same workbook. The list is connected via ODBC to our accounts package called Sage. It is this data that populates the fields to make it easier for the sales dept to complete the info for existing customers. What I wish to do is add new customer records. I imagined that I could add a button that cleared the fields and allowed the addition of the new record.
Obviously the data validation rules step in to disallow the addition of new records.
The list used for data validation can be made to be dynamic so that new entries on the list will automatically be included in the data validation.
Here is a very simple example of a dynamic data validation list on Sheet2 and the Drop Down listing is in Sheet1!A1. The formula used for the data validation is
Formula:
Please Login or Register to view this content.
Maybe you can adapt this idea to your actual situation substituting the OFFSET addresses in the formula with the reality of your workbook.
Hi newdoverman
Sorry, I can't quite grasp what happens.
On the example spreadsheet I can't see the data validation or where the formula works.
I've enclosed the spreadsheet that we use.
Data validation is used in customer acc ref field "info"D2 and the source is the "customers" worksheet.
Thanks again for helping.
I gave the table column an easy name to remember CUSTOMERS and changed the reference for the drop down Data validation list to =Customers. This will give you a dynamic listing of the first column of the large table that you have on the customers worksheet. Any customers that you add or subtract to/from the list will automatically be included or deleted.
Hi newdoverman
Thank you, that works.
Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks