Excel macro. how to fix a column so that it could only enter
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Excel macro. how to fix a column so that it could only enter

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

    Default

     
    in my assignment,i need to fix a few column so that the column only allow user to enter numeric number in that particular column.it will prompt the user if the user enter non numeric number in it.Pls help me since i am new in excel macro.

  2. #2
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Did the assignment specifically say it had to be a macro?

    If not, just use Data Validation.
    Kristy

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

    Default

      
    he just suggest using excel macro. which 1 is easier? how to use data validation?
    pls help.

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