Hi I
have problem
1., not working combo box, I dont know wha dont working
2., call sub with sheets name , I dont know syntax what I want to do
I want use button "Copy - call sub sorting + change year"
FILE : - callSub.vA004.xlsm
Hi I
have problem
1., not working combo box, I dont know wha dont working
2., call sub with sheets name , I dont know syntax what I want to do
I want use button "Copy - call sub sorting + change year"
FILE : - callSub.vA004.xlsm
Last edited by Marianus; 06-30-2013 at 03:38 PM.
Hello,
what exactly isn't working? If you mean that the combobox is empty this is because it is filled every time the sheet is activated and the following event is triggered:If you want the combobox to be filled when you open the workbook paste the following into the "ThisWorkbook" module:Please Login or Register to view this content.
If there is sth else which isn't working please be so kind to explain the problem.Please Login or Register to view this content.
Please use [CODE]-TAGS
When your problem is solved mark the thread SOLVED
If an answer has helped you please click to give reputation
Read the FORUM RULES
thanks , one moment please I do new excel (use your answer ) great , thank you
syntax what working good
I want this , but my syntax is not goodPlease Login or Register to view this content.
I want use button "Copy - call sub sorting + change year" (I want change sheet with combobox , name of worksheet is year )Please Login or Register to view this content.
try this in "CommandButton2_Click" on the "Report"-sheet
Please Login or Register to view this content.
Its interesing problem , working only year is 2012
Sorry . Im stupid I find error , my fault
this is working sheet , thank you for help
Hi,
the button "Copy - call sub sorting + change year" in this file: - callSub.vA004.xlsm it works for 2012 and 2013 for me
HI ok thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks