excel visual basic training - data validation

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel visual basic training - Data Validation

excel visual basic training - Data Validation

resolvedResolved · Low Priority · Version Standard

Haninder has attended:
Excel Advanced course

Data Validation

How do stop repetitive data form occuring when validating cells with restrited data.


i.e Id
e011
e021
e011 - when this value entered again, it should say error due to it already been entered. How do this?

Many Thanks

RE: Data Validation

Hello Haninder,

Hope you enjoyed your Microsoft Excel course with BEST Training.

What you are reffereing to is unique values. As a default in Excel, I do not know of a way you can acheive this, although having said that, there may be on of our trainers that could answer your question.

What I can say is that if you were using Microsoft Access, then you would be able to do this very easily. You would simply set the field to being a Primary Key, or set the property that is called ALLOW DUPLICATES to NO.
This will restrict the data in the field to uniques.

As Excel is more open ended and user friendly, it does not contain that capacity. You may be able to achieve using VBA coding, as then you have access to any part of Excel that you choose.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps

you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer


 

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips


Server loaded in 0.09 secs.