![]() |
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