Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Pleeeaseee help! How do I create a user form that will retri

  1. #1
    Guest

    Default

    How can I create a form that will have a box, where I can type a number (a job#) from my column A1, and it will take me to that cell. I have over 3000 jobs, and I hate scrolling every time. I want to be able to type the number in the box, and get to that cell in the column.
    please email answer to eli.delgado@auerprecision.com
    Thanks.

  2. #2
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-11 10:58, Anonymous wrote:
    How can I create a form that will have a box, where I can type a number (a job#) from my column A1, and it will take me to that cell. I have over 3000 jobs, and I hate scrolling every time. I want to be able to type the number in the box, and get to that cell in the column.
    please email answer to eli.delgado@auerprecision.com
    Thanks.
    No userform needed. Just type Ctrl+F, and type the job number in the find dialog, and press enter. It will take you to your job number.

    HTH,

    Russell

Some videos you may like

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
  •