Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select text boxes code
Hi B
This selects them Sub select_shapes_in_col_e() Dim shape_names() shape_names = Array() n = 0 For Each ss In ActiveSheet.Shapes If ss.TopLeftCell.Column = 5 And ss.Type = 17 Then ReDim Preserve shape_names(n) shape_names(n) = ss.Name n = 1 + n End If Next ActiveSheet.Shapes.Range(shape_names).Select End Su -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select text boxes code
Hi Nicky, first time we have spoken but thanks for the text boxe code.
made a few changes but your idea was great. Greatly appreciated! Thanks, B -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select text boxes code
Drawing toolbar Textboxes
-- Regards, Tom Ogilvy Bourbon wrote in message ... Hi Nicky, first time we have spoken but thanks for the text boxe code. I made a few changes but your idea was great. Greatly appreciated! Thanks, B. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to select multiple text boxes in excel for formatting | New Users to Excel | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
Cannot select text boxes | Excel Discussion (Misc queries) | |||
Control plus click will not select multiple boxes | Excel Worksheet Functions | |||
How to select all hidden text boxes | Excel Discussion (Misc queries) |