How can i get vba to get a value from a combobox and make it run a macro

M

MelonFuel

Joined
Jun 15, 2012
Messages
5
Reaction score
0
Hi

How can i get vba to do this.

When i click a button on the main form the vba code will execute and get the value from the combobox ie TE4700 and locate the macro with the same name ie TE4700 with reports in then it will run the macro and print off the reports.

Thanks MelonFuel
 

Attachments

  • macro.PNG
    macro.PNG
    32.9 KB · Views: 155

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i get the value from a comboxbox and link it to print. 0
Run Macro If Cell have "x" value 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Module to run a macro 2
VBA code for combobox 5
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
fill a field from a combobox 7
Create a filtered list (form or report) from a parameter selected in a ComboBox 1

Top