Replace value in worksheet vba

[Darren Smith]

Trying to replace a value with a different value in a column of a worksheet using a value from a combo box.
When I click the Combobox nothing happens?

Private Sub Rear_Wheels_Click()

 Dim ws As Worksheet
 Set ws = ThisWorkbook.Worksheets("Job Card Master")
   
    Select Case Me.Rear_Wheels.Value
                  
              Case ("Double")
              
              ws.Range("E13:E299").Replace what:="Single", replacement:="Double"
                  
              Case ("Single")
              
              ws.Range("E13:E299").Replace what:="Double", replacement:="Single"
                  
              
              End Select
              

              
End Sub

 

[My Aswer Is This]

This works for me.
Are you sure about the search ranges?

 

[My Aswer Is This]

You need to click on the value Double or Single in the Combobox.

 

[My Aswer Is This]

Here is how I wrote it:

Private Sub Rear_Wheels_Click()
'Modified  4/21/2021  7:21:53 AM  EDT
Dim ws As Worksheet
 Set ws = ThisWorkbook.Worksheets("Job Card Master")
   With ws.Range("E13:E299")
        Select Case Me.Rear_Wheels.Value
                  
            Case ("Double")
                    .Replace what:="Single", replacement:="Double"
            Case ("Single")
                    .Replace what:="Double", replacement:="Single"
        End Select
    End With
    Rear_Wheels.ListIndex = -1
End Sub

 

[Darren Smith]

Sorry, still not working any chance I could send my workbook to you?

 

[My Aswer Is This]

Sorry, still not working any chance I could send my workbook to you?

What does not working mean?
What is it doing wrong?
Does it throw up a error message?
I never down load files posted on this forum
So in the Combobox you select Double then cell values should change to Single

 

[Darren Smith]

What does not working mean?
What is it doing wrong?
Does it throw up a error message?
I never down load files posted on this forum
So in the Combobox you select Double then cell values should change to Single That`s right then the same other way round

It`s not doing anything & there is no error massage?

 

[My Aswer Is This]

It`s not doing anything & there is no error massage?

So you are sure you have those values in the Range you showed in your script.
And you have the exact term Double and single loaded into the Combobox and you select Double or Single
And these values must be exact.

 

[Darren Smith]

I copied the value off the worksheet to the code. So could not be any different?

 

[My Aswer Is This]

I copied the value off the worksheet to the code. So could not be any different?

And your sure you have the correct values loaded into the Combobox.
You should select the value in the Combobox not enter the values manually into the Combobox