Trying to update one or group of cells on change with VBA

pb0759

New Member
Joined
Apr 18, 2019
Messages
14
Hello,
I am trying to update when users change one or group of cells within a range when there is a space to replace with an underscore. It is working, however with a group a cells, perhaps like copy or control enter, the values only update after you click on each cell. Works okay when one cell is clicked.
Example if select at range of Cells an input "Location 1" then expected result would be Location_1.



Private Sub Worksheet_SelectionChange(ByVal Target as Range)
Dim loc as Range, res as string
Set loc = Range("A1:A20")

If Not Application.Intersect(loc, Range(Target.Address)) _
Is Nothing Then

Application.EnableEvents = False

For Each loc in Target
res = (Replace(loc.Value, Space(1), "_")
loc = res
Next loc

Application.EnableEvents - True

End If

End Sub
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top