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

Mar 11th, 2002, 11:57 AM

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.

Jack in the UK · Mar 11th, 2002, 01:00 PM

http://www.mrexcel.com/board/viewtop...1934&forum=2&1

This tells of my post how to select range and find fast

give it a go, poss quick fix

Mar 11th, 2002, 01:00 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	http://www.mrexcel.com/board/viewtop...1934&forum=2&1 This tells of my post how to select range and find fast give it a go, poss quick fix __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 11:57 AM	#1
Guest Posts: n/a	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.