Define/re-define the row source with

ComboBox1.RowSource = ActiveSheet.Name & "!$P$1:$P$300"

When you do this needs to be controlled, maybe the worksheet activate event?

--

Regards,
Nigel




"Patrick C. Simonds" wrote in message
...
I have a UserForm with a ComboBox. The current RowSource for the ComboBox
is shown below. Is it possible to make the RowSource be the range
$P$2:$P$300 of the active worksheet? I have 12 different worksheets that
can call this one UserForm.

'Names'!$P$2:$P$300