Results 1 to 6 of 6

userform textbox that searches column b

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-08-2006
    Posts
    203

    userform textbox that searches column b

    I have spent hours scrolling up and down this sheet looking for part numbers, so I created a userform with 2 textboxes. I want to enter a part number in the first textbox, and have the macro select the cell in column B that contains that part#. Then I will tab to the second textbox and enter a quantity. When I tab back to the first textbox, the quantity should paste into the next empty cell in the same row of the part# from textbox 1.

    Textbox1 = 4110  Textbox2 = 500
    
    	B	C	D	E
    1	1010	25		
    2	1020	14	15	
    3	1030	19	11	
    4	2020	100	10	
    5	2030	23		
    6	4100	67		
    7	4110	24		
    8	4150	24		
    9	5010	10
    On first tab, cell B7 would be selected, on second tab, 500 would be placed in cell D7.

    I tried converting code from a similar post, but I ended up with extra code that crashes excel every time I try to save the file.

    Any help is appreciated,

    Thank you


    (I already know how to create a userform and set up tab orders)
    Last edited by iturnrocks; 12-04-2008 at 12:15 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1