Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check boxes + autofilter - is it possible?
hello,
I'd like to use Excel in automation mode to create a worksheet in which consecutive columns of a row contain 1) a checkbox and 2) a label. I am a beginner in this subject and all I have done so far is only filling "a label" column using a code similar to: oE = new ActiveXObject('Excel.Application'); oW = oE.Workbooks.Add(); oW.Activate(); for(i=1;i<n;i++) { .. oW.Worksheets(1).Cells(i,2).value = Label(i); .. } I have two questions: 1) Is it possible "to link" a check box with appropriate "label" cell within the same row, in a way which allows to use autofilter on "label" column, and which make "linked" check box to disappear as label is filtered out, and appear again when a label is not filtered? 2) Is it possible to do this with VBA or JScript, and how? I would greatly appreciate your help and suggestions. Any link/example/www resource/tutorial would be very helpful. thanks, DD. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
check boxes + autofilter - is it possible?
Check your other post for an alternative suggestion.
Dirk Diggler wrote: hello, I'd like to use Excel in automation mode to create a worksheet in which consecutive columns of a row contain 1) a checkbox and 2) a label. I am a beginner in this subject and all I have done so far is only filling "a label" column using a code similar to: oE = new ActiveXObject('Excel.Application'); oW = oE.Workbooks.Add(); oW.Activate(); for(i=1;i<n;i++) { .. oW.Worksheets(1).Cells(i,2).value = Label(i); .. } I have two questions: 1) Is it possible "to link" a check box with appropriate "label" cell within the same row, in a way which allows to use autofilter on "label" column, and which make "linked" check box to disappear as label is filtered out, and appear again when a label is not filtered? 2) Is it possible to do this with VBA or JScript, and how? I would greatly appreciate your help and suggestions. Any link/example/www resource/tutorial would be very helpful. thanks, DD. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
Check Box influencing other Check Boxes | Excel Programming |