Skip to content

Instantly share code, notes, and snippets.

@spences10
Last active October 23, 2016 06:26
Show Gist options
  • Save spences10/60fdc5c2e4d59e9223d50e77558e16cb to your computer and use it in GitHub Desktop.
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…
combobox1.list = application.transpose(rs.getrows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment