Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaration of array
i am trying to create a macro which will delete the excel rows based on some
values. i have kept some check boxes Eg: checkbox1, checkbox2,checkbox3 are there in the macro code if the user has checked the box1 & 3 then we have to keep only the rows which as the checkbox1.caption and checkbox3.caption. please let me know a way to resolve this |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaration of array
As a general rule, in Excel when deleting rows its best to delete from the bottom up to make sure you don't get undesired results, as for the rest, why not post the code you have for you check boxes?, where are the checkboxes? which menu did you get the checkboxes from? pramod;235626 Wrote: i am trying to create a macro which will delete the excel rows based on some values. i have kept some check boxes Eg: checkbox1, checkbox2,checkbox3 are there in the macro code if the user has checked the box1 & 3 then we have to keep only the rows which as the checkbox1.caption and checkbox3.caption. please let me know a way to resolve this -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65762 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Declaration. | Excel Discussion (Misc queries) | |||
Array Declaration Problem ?? | Excel Programming | |||
Array Declaration | Excel Programming | |||
dYNAMIC Array declaration, a small correction in my last thread! | Excel Programming | |||
Declaration? | Excel Programming |