Consulting

Results 1 to 4 of 4

Thread: Solved: Limit input characters in a cell

  1. 08-09-2010, 01:40 AM #1
    rachell_8
    rachell_8 is offline
    VBAX Regular
    Joined
    Aug 2010
    Posts
    23
    Location

    Solved: Limit input characters in a cell

    hi, how do i limit the input characters for merged cells (example: limit input to 35 characters only)? Thanks!
    Reply With Quote Reply With Quote
  2. 08-09-2010, 01:56 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Use Data Validation.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  3. 08-09-2010, 02:09 AM #3
    aysam
    aysam is offline
    VBAX Regular
    Joined
    Aug 2009
    Posts
    22
    Data Validation ==> Text Length ==> equal to ==> 35
    Reply With Quote Reply With Quote
  4. 08-09-2010, 05:51 PM #4
    rachell_8
    rachell_8 is offline
    VBAX Regular
    Joined
    Aug 2010
    Posts
    23
    Location
    thanks! it works!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules