Attached is the file that contains activex buttons. I appreciate your help...
Thank you.
Attached is the file that contains activex buttons. I appreciate your help...
Thank you.
Last edited by christlivethinme; 06-22-2012 at 05:00 AM.
I am not seeing any values in your dropdowns for both options.
Also, how are you ensuring that the user doesnt click both option boxes?
When you say the formatting for sheets A & B should be retained? Do you mean the formatting in the new files that are created?
In what format should the new file be? Should it have the filtered data for each respective sheet in its own sheet? Where should the file be saved and in what name?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi,
Just had a short look at it, it's a project all right, i will not do it all, but will instead point you in the right direction.
You populate a combobox like this
If the combobox should hold a lot of values then create an array and asign the values to the combobox listPlease Login or Register to view this content.
Next you should look in to the "Combobox_change" event
next up you create a new workbook, you can read how herePlease Login or Register to view this content.
http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx
Next you copy the data, here you should look into specialcells to copy only visible part of sheets 2 and 3
After coppying you save the new workbook, this you can read about in the link given earlier or in more detail here:Please Login or Register to view this content.
http://www.rondebruin.nl/saveas.htm
Clear the filter and your done!
If you have en specific questions along the way feel free to ask them here
Last edited by Steffen Thomsen; 06-22-2012 at 04:30 AM.
Please take time to read the forum rules
Hi Sir,
I have updated the file pls ignore and delete the other one.
the formatting of the sheets a and b should also be retained in the new file.
the new file will be in excel 2003 format
ill take care of the filename, the new file should contain sheet a and b only, instructions sheet not included.
Should all 8 file be generated every time? If this is the case i think you going about it the wrong way.
The code for the populating the comboboxes should only be run once if they never change and therfore be placed in a module and then deleted.
The combobox change event should be placed in the first sheets codemodule, so should the "CommandButton1_click" event
apologies for the confusion, the objects that i created are form controls, it should be activex
I think you should start creating the macros you need with the information given, if you have questions for pieces of code you have written then feel free to ask.
Split up the project in smaller pieces.
1. Create the comboboxes and build the code to populate them.
2. Create the filter when a value is changed in the comboboxes
3. Create the commandbutton action to copy data from the filtered sheets to a new workbook.
4. Optional - Create a command button to create all
I appreaciate your help guys, ill be waiting for your responses.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks