Home |
Search |
Today's Posts |
#1
|
|||
|
|||
problems with macros
I want to record a macro for advanced filtering . Is that possible? the scenario: i want a box named "remove filter" and a box named "apply filter". The apply fiter is based on a criteria with a list on the same worksheet. Can anyone help me with this? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=465795 |
#2
|
|||
|
|||
you can have two macros
1. to do advnacae filter 2. remove this filter number 2 is some sort of ;undo of 1 for both use record macaro button "cjjoo" wrote in message ... I want to record a macro for advanced filtering . Is that possible? the scenario: i want a box named "remove filter" and a box named "apply filter". The apply fiter is based on a criteria with a list on the same worksheet. Can anyone help me with this? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=465795 |
#3
|
|||
|
|||
a macro will record all the actions that i have taken. Is that rite? so for "apply advanced filter" , i have to goto record new macro these are the steps that i took data filter advanced filter a popup will appear and i have to define the list range follow by the criteria range stop recording.. but once i run the macro from a text box (assign macro), there is an error. i dont know if these are the rite steps to take. ANy recommendations? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=465795 |
#4
|
|||
|
|||
try creating a command button and assign macro
or copy the code under <view code. "cjjoo" wrote in message ... a macro will record all the actions that i have taken. Is that rite? so for "apply advanced filter" , i have to goto record new macro these are the steps that i took data filter advanced filter a popup will appear and i have to define the list range follow by the criteria range stop recording.. but once i run the macro from a text box (assign macro), there is an error. i dont know if these are the rite steps to take. ANy recommendations? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=465795 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Purge macros | Excel Worksheet Functions | |||
Has anyone experienced problems with Macros when upgrading to Off. | Excel Worksheet Functions | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) |