ComboBox Rowsource question
I like to let excel do the heavy lifting...
Dim myRng as range
set myrng = activesheet.range("p2:p300")
....
... = myrng.address(external:=true)
------------
If you want to supply the string yourself:
... = "'" & activesheet.name & "'!p2:p300"
(Some names will require those apostrophes.)
"Patrick C. Simonds" wrote:
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
--
Dave Peterson
|