Re: Validating data pasted into worksheet

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Do you have any sample code?

"Dave Peterson" wrote:

> This seems like a very reasonable approach.
>
> Tom F. wrote:
> >
> > I have an application that has a user paste data into a set group of columns
> > and up to 100 rows. The data is sales information. They then click a button
> > and the data is exported into a flat file. I need the data to be validated
> > before the flat file is created. 1. I need field length validation on some
> > columns (13 characters max) and 2. I need the data in two columns to be
> > validated against a code list (MN, KN, TD, or GD). I am thinking that doing
> > this as a Macro is best because selecting the "Data" "Validation" for a
> > range is erased once new data is pasted into a cell.
>
> --
>
> Dave Peterson
>
.

Relevant Pages

  • Re: Combo Box
    ... When you show the properties window to show change the .matchentry property, ... "Dave Peterson" wrote: ... the data validation, i use it for the drop down list. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Data Validation and Macros
    ... "Dave Peterson" wrote: ... Dim NewRating_1 As Range ... I have a spreadsheet that tracks inspection dates and ratings. ... The ratings are picked from a validation list, ...
    (microsoft.public.excel.programming)
  • Re: Combo Box
    ... the data validation, i use it for the drop down list. ... i highlight the cells that i want for the dropdown list, data, validation, ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Check for incorrect characters
    ... I'll use both validation and this method, ... Dave Peterson wrote: ... Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) ... letters, or commas, spaces, apostrophes, and full stops. ...
    (microsoft.public.excel.programming)
  • Re: How do I do this?
    ... If you're trying to do the validation in VBA, here's some sample code ... dropdown box on that cell. ...
    (microsoft.public.excel.programming)