Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkBox & ListBox on ToolBar...
Is that possible to have an checkBox and/or ListBox on
the toolbar.... so the code bellow will be run if checkBox is check, and listBox pointing to currency... Thank You / How to modify the content of the current Cell in Excel // put this code in Excel/VisualBasic/MsProject/ExCellObject/Worksheet1 Private Sub Worksheet_Change(ByVal Target As Range) Dim x As String x = Target.Value If Right(x, 1) = "*" Then Target.Value = Replace(x, "*", "000") End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to have checkBox in ToolBar (Icon) ? | Excel Programming | |||
Adding CheckBox Caption to a Listbox | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
listbox with checkbox or radiobutton groups | Excel Programming | |||
Listbox w/CheckBox Options | Excel Programming |