Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Nov 2001
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    As Datasheet (Excel 2000 SR-1)

    User has list of 150+ names/addresses which are frequently used in a list of receipts. Is there any way to create shortcuts of these similar to AutoCorrect in Word? Validation list doesn't work because there are many many other entries besides the 150+.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: As Datasheet (Excel 2000 SR-1)

    Hi,
    Is there a reason you can't use Excel's AutoCorrect function? (Under Tools-Autocorrect)
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: As Datasheet (Excel 2000 SR-1)

    Brenda

    MS-Excel 2000 does have AutoCorrect, its under the Tools Menu, so you need to add the entries into your auto-correct list and you are good to go. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    Here is an example of how to do it in VBA:

    Application.AutoCorrect.AddReplacement What:="wassim", Replacement:= "Wassim"

    Hope this helps

    Wassim <img src=/S/hello.gif border=0 alt=hello width=25 height=29>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    Lounger
    Join Date
    Nov 2001
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: As Datasheet (Excel 2000 SR-1)

    The text is a 3-4 line address with breaks. Is there a way to put line breaks in Autocorrect?

  5. #5
    Lounger
    Join Date
    Nov 2001
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: As Datasheet (Excel 2000 SR-1)

    It looks like we've got it. Someone else suggested a validation list, but setting the Error Alert Tab to DEselect the "show Error Alert after Invalid Data is entered". That allows us to enter a name/address that is not contained in the validation list but still gives up the drop-down list of those we use regularly. I was not aware this could even be done, so *I've* learned something new today! Thanks for the suggestions.

Posting Permissions

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