BetterBeef
New Member
- Joined
- Mar 18, 2010
- Messages
- 42
I was wondering if it is possible to set a rowsource of a combo box that I am using on a form in VBA (for Excel) using multiple ranges. For example, I would like to use the values in 'Sales Update'!A44:A51 and 'Sales Update'!A53:A63 to show up as one list in a combo box.
Is this possible or is there a way around this? I tried using Union() to bind them together, but it gave me an error message.
Any thoughts?
Is this possible or is there a way around this? I tried using Union() to bind them together, but it gave me an error message.
Any thoughts?