Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hello I use this code to change visible true/false of some controls in my workbook. I get SheetName, ShapeName and true/false (0 or -1) from a database. I do this to create user levels Sheets(SheetName(i)).Shapes(ShapeName(ii)).Visible = -1 This works well but now I want to also access controles is in userform. I also want to change caption on the controls if it's possible. Excuse my bad English but I hope you understand the question anyway Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Programming | |||
TRUE/FALSE BOX not activating a WS change | Excel Discussion (Misc queries) | |||
ComboBox.visible = False or True | Excel Programming | |||
Shapes.visible = false/true | Excel Programming |