ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to have checkBox in ToolBar (Icon) ? (https://www.excelbanter.com/excel-programming/407370-how-have-checkbox-toolbar-icon.html)

Johan2000

how to have checkBox in ToolBar (Icon) ?
 
Dear Sir,

I have a piece of code (replace 3** with 3000000)

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

Is there any way that It would be easy for the user to activate/deactivate
the replacement with a click of checkbox (prefereble in the toolsBar) that is
very accessible.
What would be the best solution for activat/deactivate the REPLACEMENT?

thanks!



All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com