RowSource

[Patrick Simonds]

I have a UserForm with a ComboBox. I want to enter a RowSource in the
RowSource property but having no luck in formatting it in a way that excel
will accept. I want the RowSource to be A5:D45 of the Outstanding Checks
worksheet. The help file (Excel 2007 beta) was of no help.

[Patrick Simonds]

Figured it out:

'Outstanding Checks'! $A$5:$D$45

"Patrick Simonds" <[email protected]> wrote in message
news:[email protected]...
>I have a UserForm with a ComboBox. I want to enter a RowSource in the
>RowSource property but having no luck in formatting it in a way that excel
>will accept. I want the RowSource to be A5:D45 of the Outstanding Checks
>worksheet. The help file (Excel 2007 beta) was of no help.
>