textbox macro object required error

[dshafique]

Good morning Everyone. I am creating a macro where users put something in a textbox, and it turns green after someone checks it. all i needed was for the textbox to turn green, but when i put in the code, it says object required.

Sub Jira()ActiveSheet.Shapes("TextBox25").Select
TextBox25.BackColor = RGB(0, 255, 0)


End Sub

thanks in advance!

 

[Misca]

Try something like

With ActiveSheet.Shapes("TextBox25")
    .Fill.ForeColor.RGB = RGB(0, 255, 0)
End With

 

[dshafique]

I still get the error saying object required

 

[Misca]

My guess would be the TextBox name in the macro is incorrect / misspelled.

Also, try recording a macro where you select the text box and change the color to a special RGB color. That way you'll get a rough guide for the code you're looking for. Usually it's a good thing to try to write the final code without selections. This way you can run the macro without having to think which sheet happens to be activated.