Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ActiveX controls
Hi
Is it possible to designate a cell as a control box and link a macro to it rather than using one of the ActiveX controls? Many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ActiveX controls
If you don't want an ACtiveX control, you could use a checkbox from the
Forms toolbar. An alternative is this methiod which is invoked by selecting a cell 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Const WS_RANGE As String = "H10" '<=== change to suit If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target If .Value = "a" Then .Value = "" Else .Value = "a" End If .Font.Name = "Marlett" .Offset(0, 1).Activate End With End If End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Luke" wrote in message ... Hi Is it possible to designate a cell as a control box and link a macro to it rather than using one of the ActiveX controls? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX Controls | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Anchoring Activex Controls | Excel Discussion (Misc queries) | |||
After installing Office XP SP3, Excel ActiveX controls are moved a | Excel Discussion (Misc queries) | |||
ActiveX Controls Display Issue? | Excel Discussion (Misc queries) |