I_AM
Board Regular
- Joined
- Jul 2, 2002
- Messages
- 141
Hello,
I have an AddIn named "RvP.xla", with a userForm(1) containing a ComboBox(1).
The Addin has a sheet(1) with a range named
"Venue" = $C$6:$C$9
I wish to set the Rowsource of ComboBox1 to the above Addin/Sheet/Range.
How do I do this?
I have tried this,(and many many variations)
Sub UserForm_Initialize()
ComboBox1.RowSource = Sheets("RvP.xla") ("Sheet1!$C$6:$C$9").Value
End Sub
The above,and all my other variations, only produce errors.
Thanks Regards Ron
I have an AddIn named "RvP.xla", with a userForm(1) containing a ComboBox(1).
The Addin has a sheet(1) with a range named
"Venue" = $C$6:$C$9
I wish to set the Rowsource of ComboBox1 to the above Addin/Sheet/Range.
How do I do this?
I have tried this,(and many many variations)
Sub UserForm_Initialize()
ComboBox1.RowSource = Sheets("RvP.xla") ("Sheet1!$C$6:$C$9").Value
End Sub
The above,and all my other variations, only produce errors.
Thanks Regards Ron