Mister_joe
01-30-2014, 08:35 AM
People,
Do not punch on the nose. VBA is turning out to be a mountain in front of me. The more I try to go deeper into it the more confusing it seems to be. I spent several hours today just to find out that a VBA Option Button control does not support the Checked property. I am still wondering why a VBA TextBox control has a Text property as well as a Value property. And also, that the well known PictureBox is not PictureBox in VBA. So, VBA is not VB? I am trying to programme Excel worksheet to have a custom user interface and to execute custom codes. I reckon that I will not go far in this task if I have to learn about a particular VBA control at the time I need it. Please, does anyone know a good book that explains VBA controls and syntaxes? I am not talking of Excel macros, I am talking of the underlying principles upon which Excel macros are written. If you assist in this, you would have contributed meaningfully in relieving me of some stress. Thank you sincerely.:banghead:
Do not punch on the nose. VBA is turning out to be a mountain in front of me. The more I try to go deeper into it the more confusing it seems to be. I spent several hours today just to find out that a VBA Option Button control does not support the Checked property. I am still wondering why a VBA TextBox control has a Text property as well as a Value property. And also, that the well known PictureBox is not PictureBox in VBA. So, VBA is not VB? I am trying to programme Excel worksheet to have a custom user interface and to execute custom codes. I reckon that I will not go far in this task if I have to learn about a particular VBA control at the time I need it. Please, does anyone know a good book that explains VBA controls and syntaxes? I am not talking of Excel macros, I am talking of the underlying principles upon which Excel macros are written. If you assist in this, you would have contributed meaningfully in relieving me of some stress. Thank you sincerely.:banghead: