Finding row value of specific text

**newguy99** · 08-10-2010, 10:11 PM

Incredibly new to programming in excel so feel free to flame if I dont describe what i'm looking for accurately:

Attempting to develop a userform to edit data contained within a sheet. I want the user to type text into a box and have the form auto-populate based on the data in the row containing the specified text. The only resource I have found for autopopulating a userform is via specifying the row # the data is contained in.

Please help!

**pike** · 08-11-2010, 06:13 AM

Hi newguy99
welcome to the forum
you could find the row address with this example from the VBA help files

Please Login or Register  to view this content.

**newguy99** · 08-11-2010, 07:56 AM

Thanks for the rapid response! Unfortunately I am increadibly new to using VBA and am having a hard time deciphering how to apply this code to my project. Could someone be kind enough to give me the quick rundown on that section of code?

**pike** · 08-11-2010, 07:59 AM

hi newguy99
can you attach a sample workbook and i can add the code?

**newguy99** · 08-11-2010, 08:54 AM

In this sample, if I create a userform and a user inputs the city name, I want the county, population, age, literacy to auto-populate. The only way I think i can do this is using the cells method; and to do so I need the row number of the user-entered city. Of course, this is just my meager understanding thus far.