MACRO SCRIPT

Hi friends i want your help if someone can help.Can you tell me how i can marking all the letters that its inside the parentheses ,so i can make them red ?

Option Explicit


Private Const STARTCHAR = TextBox1.Text
Private Const ENDCHAR = TextBox2.Text
Private Const FINDCOLOR = RGB(0, 0, 0)
Private Const REPLACECOLOR = RGB(255, 0, 0)

Dim StartPos, EndPos As Integer


Private Sub CancelButton_Click()
Application.Quit
End Sub