Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A very simple question....
Since i have just discovered the VBA-part of my office
2000 i have a - presumably - very simple Q. I wish to create a procedure that can change the colour of all the controls on a particular worksheet in a workbook. i.e. I have 6 optionbuttons and two checkboxes on a sheet I wish to assign a certain color to. I know how to extract the colour from a cell, assign it to a long-variable... But then.... My problem is to cycle through all the controls on a given sheet, assign the variable to the individual control(Since it seem as the OLEObjects dont have the .Backcolor property) Sorry for this obviously simple Q, but i have to start somewhere.... (And for me it isnīt simple- on the contrary) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple question.... | Excel Discussion (Misc queries) | |||
Simple question..I think | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple Question | Excel Programming |