Last active
October 23, 2016 06:26
-
-
Save spences10/60fdc5c2e4d59e9223d50e77558e16cb to your computer and use it in GitHub Desktop.
Combobox rowsource = recordset, a nice way to bind a ADODB recordset to an excel combobox, this way you can also use the bound column. *NOTE* you will need to swap the bound column with the column you want to display the data for as if bound column is 1 then and you have two combobox columns with one hidden like 0 pt; 40 pt the bound column data…
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
combobox1.list = application.transpose(rs.getrows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment