VBA Listbox selection, connected to textbox

[silvertyphoon1]

The Lookup information is found on a sheet called “Lookup” the sheet has information is columns A-G. The userform has eight option buttons, a listbox and two textboxes. Column 1 of “Lookup” sheet contains a number that corresponds to a manufacturer of light bulbs. The numbers 1-8 are used to determine which manufacturer it is. Each manufacturer produces a number of bulbs as well. When the user selects an option button the list of bulbs for that given manufacturer is displayed for selection in the listbox. I also have a text field called Length and Wattage. The length is found in the F column of the “Lookup” sheet and the wattage from the E column of the “Lookup” sheet. I would like the corresponding values to populate the text boxes if a bulb is selected in the listbox. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Note: The wattage numbers are values from 1.3-6.3, when it displays I’m looking for values less than 4.04 being displayed as “<4” and values above 4.04 being displayed in the wattage textbox as “4-7.5”. So based on what the wattage is for that particular bulb only one of those two options should be displayed in that textbox. The length can be displayed as it is.<o></o>