PDA

View Full Version : Solved: Forms in VBA



khalid79m
02-11-2009, 09:54 AM
Firstly all I have no exprience with building forms etc, so please bear with me if I ask stupid questions.

I have a sheet labelled CallData, This has a several column headers which are Staff_Number, Name, (Ps the column headers are the names of the named range , eg Staff_Number = a2:a10000 and Name = B2:b10000

Now on the other sheet CallForm I need to have a drop down box linked to the staff numbers which is easy peasy but what i need it to do is once this is populated , place a filter on calldata sheet for that staff member and also bring back his or her name,

can anyone help a beginner??

Bob Phillips
02-11-2009, 03:35 PM
=VLOOKUP(A2,CallData!A2:B10000,2,FALSE)

khalid79m
02-19-2009, 05:31 AM
thanks worked