Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change visible true/false of controls
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change visible true/false of controls
What type of Control, ActiveX (control Toolbox) or Forms. Also what is it,
eg checkbox. Regards, Peter T "kalle" wrote in message ... 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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change visible true/false of controls
Thanks på your answer. It is the ActiveX control and it's checkbox and commndbutton. *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change visible true/false of controls
Dim oleObj As OLEObject
Set oleObj = Worksheets("Sheet1").OLEObjects("CheckBox1") oleObj.Visible = True ' or False oleObj.Object.Caption = "New Caption" Similar for the commndbutton Regards, Peter T "kalle" wrote in message ... Thanks på your answer. It is the ActiveX control and it's checkbox and commndbutton. *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change visible true/false of controls
Hello Thank you very much. This works fine but now I need to do the same thing on my userforms. Is that possible? *** Sent via Developersdex http://www.developersdex.com *** |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change visible true/false of controls
Dim img As MSForms.Image ' or simply As Control
Set img = Me.Controls("Image1") img.Picture = LoadPicture(sFile) Regards, Peter T "kalle" wrote in message ... Hello Thank you very much. This works fine but now I need to do the same thing on my userforms. Is that possible? *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |