combobox calculations

[mighty_man]

Hi there,
I've populated my combobox from an excel sheet using vba.
I then scroll down the combobox looking for the line i want.
I want now to perform calculations on the selected line of my combobox, and have the result displayed in a Msgbox or else passed to a seperate worksheet.

Any ideas?
Thanks,
John

 

[royUK]

It's not really clear what you are trying to do

 

[mighty_man]

combobox question (take 2!)

I'm using a combobox on a userform in order to scroll through data set in an excel sheet.

This sheet has values in it from columns A to G and from rows 1 to 200.
Column A has the values for temperature and columns B to G contain the peak position at different measurement intervals.


I hope you're still with me?!
When i see the line i want when i'm scrolling down - say i see that there's an entry for temperature 45 degrees in column A, then i want to use the peak position values from columns B to G to calculate the overall peak value.

I want to do this in VBA.
Hope this makes it clearer,
John