[RESOLVED] EXCEL: Auto-populate cells using combo boxes

[rsutt1]

Hello,

I have a workbook with lots of airport information stored in, I want to bring that information into anouther workbook by selecting a specific airport in a combo-box. I have never used VB before so please be gentle. Any help would be appreciated.

[rsutt1]

I'm lost already, I'll give it a go though. Probably be back in about 20 mins begging for more information.

[rsutt1]

Ok, getting somewhere but still need assist:

I did as you said and it works great but regardless of what i select in my combox it always gives the results of the same airport, regardless of the one selected in the combox. I tried to change the code a little but it now tries to copy the whole colum rather that just the selected row.... HELP!!

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 19/01/2007 by Ryan Sutton
'

'
Windows("Airports.xls").Activate
Range("B:C").Select
Selection.Copy
Windows("Book2.xls").Activate
Range("B8:C8").Select
ActiveSheet.Paste
Range("F14").Select
Windows("Airports.xls").Activate
Range("D:E").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Book2.xls").Activate
Range("B12:C12").Select
ActiveSheet.Paste
End Sub