Cannot insert cells into VBA?

Hi All,

I'm trying to insert cell reading into my exclusively VBA based program. I've learned that it's easier to update an excel spreadsheet than
update the VBA. Therefore, for the following code below, does anyone know how I could get the program to read:

Worksheet: AXLE DATA, column C4 = BRCKT010, D4 WEIGHT (3.585)


instead of:

Select Case Me.ComboBox20.Value

        Case "BRCKT010"
                Me.TextBox36.Value = 3.585 'weight

Can anyone assist to get me started? Many Thanks