creating a value based on combo box selection

[unityjon]

in a 'user form' I am trying to give a text selection a numerical value so i can perform a calculation with it elsewhere, my combo box has 10 entries held in a range (resourceTime) on a separate worksheet lets say ".5 day","1 day", "2 Day"etc.. When the combo box selection is "0.5 Day" i need to generate a value of "1" and so on (1 day="2", 2 day="3" etc)

Things i have tried - i have made the combo box dual column and only display the "text" rather than the numbers and extended the range to the adjacent column with numbers 1-10 but for the life of me i cannot create the code to do the sum and display the results in a textbox and place the result into a worksheet


i think the code should be something along the lines of:

Private Sub textbox4_Change()
Dim totalScore as Integer
Me.textbox4.textvalue = (Me.textbox11 + Me.textbox12 + Me.textbox13 + Me.combobox1.column(1))

End sub

or something along those lines ??

P.S i'm very new to this !! (hence asking for assistance

 

[jonathann3891]

Look at this thread and see if it helps

http://www.mrexcel.com/forum/excel-questions/80115-assigning-number-value-combobox.html

 

[unityjon]

Many thanks, managed to make that work just fine