Sorry, forgot the Set part and thanks, that helped alot. However, now I
am now getting this error message:
Run-time error '13': Type mismatch

The vlookup formula is also highlighted in yellow. When my currsor
hovers over each of the arguments in the vlookup formula, it displays
the correct value for each variable in the formula except for
TableRange. It dose not display anything for it.

Also, when I hover over the top of the Select Case statement over the
cboPrgType.Value, it gives me the correct chosen value of
"MM30YFRates". Once I hover over any of the Sets in the statement, I
don't get any values until I get to the last Set. When I hover over the

"= Range("MMS3015YBTable")" ,
which is the last set, the off-white box states

Range("MMS3015YBTable") = <Method range 'of object'_Global' failed

How can I fix this?

I really appreciate your help