Grid control that can be placed on userform?

excel adodb gridcontrol vba
tbone picture tbone · Mar 14, 2015 · Viewed 13.6k times · Source

Does anyone know of a grid control that can be placed on an Excel UserForm, preferably something that is capable of displaying the content of a ADODB Recordset?

Answer

kitap mitap picture kitap mitap · Mar 15, 2015

In VB window using 'Tools'->'Additional Controls' menu, there may be DBGrid control; check it.

Related questions

Accessing SQL Database in Excel-VBA

I am copying an VBA code snippet from MSDN that shows me how to grab results from a SQL query into excel sheet (Excel 2007): Sub GetDataFromADO() 'Declare variables' Set objMyConn = New ADODB.Connection Set objMyCmd = New ADODB.Command Set objMyRecordset = …

Read More
Excel VBA - connect to sql with a trusted connection (no uid/pwd)

Is there a way to have Excel connect to Sql Server using the current user's network windows authentication (trusted connection/integrated security)? I don't want to rely on a sql login or have a uid/password in my code.

Read More
VBA New Database Connection

How to change the code below to prevent what you see in the screenshot. I am running a macro with the following code Dim conn As ADODB.Connection Dim rec1 As ADODB.Recordset Dim thisSql As String Set conn = New …

Read More