I have a button called button1 and i want to use it's caption (text) as a parameter for my If statement.
let's say if the caption(text) is GOOD, a rectangle will be colored green. if BAD, red.
I just want to know how can I get the caption in PB VBA. Because in Excel VBA I guess I just have to use Button1.Caption?
And what refrences are needed? Like ActiveX Library or anything like that?