Data validation in Excel 95
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Data validation in Excel 95

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need to run data validation in a file saved as excel95. Is there anyone that knows how to construct a macro for this?

    Show me how to collect a value when itīs being entered in a cell and how I can check if itīs a number or not. The rest i think I can handle...

    Greetings from Sweden!

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I found this example but I canīt get it to work in my file. Does anyone have a clue?

    ------------------------------------------
    The following sample macros restrict the data type in column C of sheet 1 to numbers.


    Sub Auto_Open()
    Sheets("Sheet1").OnEntry = "numbers"
    End Sub

    Sub numbers()
    If ActiveCell.Column = 3 And Not IsNumeric(ActiveCell.Value) Then
    MsgBox "Enter a number."
    ActiveCell.Value = "" ' Clears contents of active cell.
    End If
    End Sub


    http://support.microsoft.com/default...;en-us;Q141181



    [ This Message was edited by: dansve on 2002-04-10 03:58 ]

    [ This Message was edited by: dansve on 2002-04-10 04:34 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com