Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing checkboxes
Hi, I dont have much background in programming so I need a little hel
with a piece of code a put together to erase checkboxes in a specifi range. Sub Erase3() Dim myCBX As CheckBox For Each myCBX In Range("A10:A15") myCBX.Delete Next End Sub It gives me type mismatch. What does it mean? And can anybody help me Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing checkboxes
Dim myCBX As CheckBox
For Each myCBX In ActiveSheet.Checkboxes if not Intersect(myCBX.TopLeftCell, _ Range("A10:A15")) is nothing then myCBX.Delete End if Next End Sub Assumes textboxes are from the forms toolbar. -- Regards, Tom Ogilvy "marksuza" wrote in message ... Hi, I dont have much background in programming so I need a little help with a piece of code a put together to erase checkboxes in a specific range. Sub Erase3() Dim myCBX As CheckBox For Each myCBX In Range("A10:A15") myCBX.Delete Next End Sub It gives me type mismatch. What does it mean? And can anybody help me? Thanks --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Erasing a spreadsheet | Excel Discussion (Misc queries) | |||
erasing outside print area | Excel Discussion (Misc queries) | |||
Erasing a Formula? | Excel Discussion (Misc queries) | |||
how do I replace #n/a in a formula with 0, without erasing my for. | Excel Discussion (Misc queries) | |||
Erasing a excel file | Excel Discussion (Misc queries) |