![]() |
|
#11
|
||||
|
||||
|
Those constants are all defined in Excel. In Excel these resolve as
xlBeginsWith = 2 xlContains = 0 xlDoesNotContain = 1 xlEndsWith = 3 xlNoFilter = "" The ComboBox in a VBA userform is essentially the same but when interacting with the application may cause you to use different methods to achieve the same thing. For instance a Range in Excel can be used to populate the .List property of a combobox. Word requires you to convert a Range into an array before you can populate the .List property.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Trying to get number of para in Combobox | SMehta | Word VBA | 2 | 02-20-2021 07:15 AM |
| How to autofilter by exact date? | LearnerExcel | Excel | 5 | 06-19-2018 03:30 PM |
| Autofilter on two Date Columns | OTPM | Excel Programming | 3 | 04-29-2014 12:56 AM |
Sum on AutoFilter
|
Grasshopper | Excel | 3 | 02-14-2013 01:41 AM |
AutoFilter Criteria3
|
coxjamd | Excel Programming | 2 | 01-17-2013 02:24 PM |