is the name of your combobox on Update sheet named cb_region? if so, you
don't need to declare it as a variable. Since you are only performing one
command, you can eliminate With/End With and just use

myRegion = Sheets("Update").cb_region.Value


"Bruce" wrote:

I am trying to get a value from my a combobox on my sheet "Update" but it
tells me object required.

What have I missed?


Function myRegion
Dim cb_region As ComboBox

With Sheets("Update")
myRegion = cb_region.Value
End With
End Function