Access VBA List all control names on all forms in Excel

Hi

What Access VBA code would I use to generate a list of all the control names on all forms in Access and export this list to Excel

Thanks

Microsoft AccessVBA

Last Comment

John Tsioumpris

8/22/2022 - Mon

Ryan Chong

2/18/2020

probably you could try like this:

Function test()
    Dim Sheet As Worksheet, Ctrl As Object
    For Each Sheet In Worksheets
        For Each Ctrl In Sheet.OLEObjects
            Debug.Print Sheet.Name & ": " & Ctrl.Name
        Next
        For Each Ctrl In Sheet.Shapes
            Debug.Print Sheet.Name & ": " & Ctrl.Name
        Next
    Next
End Function

Open in new window

Anders Ebro (Microsoft MVP)

2/18/2020

Are you trying to export a list of ACCESS form controls to an excel spreadsheet?
Or are you trying to list EXCEL userform controls in excel, but doing it from access?

I'm confused about your question, as both excel and Access have userforms and controls.

Murray Brown

2/18/2020

ASKER

Hi Anders. Yes to your first question "Are you trying to export a list of ACCESS form controls to an excel spreadsheet? "
My original question was badly worded

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes

ASKER CERTIFIED SOLUTION

John Tsioumpris

2/19/2020

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts