ListFillRange: How can I fill in without typing?
Posted by Rick M on February 09, 2001 8:52 AM
I am using a combo box, under the box "properties" I would like to fill in the range using the mouse by selecting the sheet and the range.
Any suggestions to easily fill this info in?
Thanks..
Posted by Dave Hawley on February 09, 2001 10:19 PM
Hi Rick
You will need VBA to do this:
ComboBox1.ListFillRange = Selection.Address
Hope it helps
Dave
- OzGrid Business Applications
