Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide Form Control
I have a forms checkbox control on a worksheet. Control is title "cbLOC".
Based on the selection of a dropdown box, I want this control to show or not show. Right now I have created a text box slightly larger than the control and superimposed over top of the checkbox. The plan is to send the checkbox control to the foreground when it needs to be available otherwise hide it in the background by sending it to the back. Code at the moment is Sheets("Inputs").Shapes("cbLOC").ShapeRange.ZOrder msoSendToBack I get a runtime error 438. Do I need to force it into "Design Mode" and how do I do that? Is there any way to simply hide the control rather than covering it up? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide Form Control
Me.cbLoc.Visible = Fals -- jt ----------------------------------------------------------------------- jtp's Profile: http://www.excelforum.com/member.php...fo&userid=2113 View this thread: http://www.excelforum.com/showthread.php?threadid=56874 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/Unhide Form Control
This will toggle it
With Sheets("Inputs").Shapes("cbLOC") .Visible = Not .Visible End With -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "qwerty" wrote in message ... I have a forms checkbox control on a worksheet. Control is title "cbLOC". Based on the selection of a dropdown box, I want this control to show or not show. Right now I have created a text box slightly larger than the control and superimposed over top of the checkbox. The plan is to send the checkbox control to the foreground when it needs to be available otherwise hide it in the background by sending it to the back. Code at the moment is Sheets("Inputs").Shapes("cbLOC").ShapeRange.ZOrder msoSendToBack I get a runtime error 438. Do I need to force it into "Design Mode" and how do I do that? Is there any way to simply hide the control rather than covering it up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide/Unhide row VBA | Excel Discussion (Misc queries) | |||
Hide/Unhide Sheets Form | Excel Programming | |||
Hide/unhide | Excel Worksheet Functions | |||
Hide and unhide | Excel Discussion (Misc queries) | |||
Checkbox Control to Hide/Unhide Worksheet | Excel Programming |