911! How do I get a reference to a radio button (Groupbox) object in excel spreadsheet macro?
Posted on 2001-06-19
OK I am desperate now! I am an OK Java and ASP developer, but in this project I am using JNI-COM bridge to MS Excel COM object excel9.olb I think. Anyway, our client wants to use thei exisisting desktop excel spreadsheet app w/ macros with our java web app. I have a GroupBox ("GroupBox14") on a Worksheet (Worksheet"AppData") which seems to be bound to the value of a range on another worksheet i.e Worksheet("Options").Range("A1B1").Value. So if GroupBox14 has 3 radio buttons, "Small", "Medium", and "Large", the values 1,2,and 3 in A1B1 would respectively be small, medium and large.
Are you with me so far? OK, I am having a hard time setting the value of the radio buttons via setting the value in A1B1. I want to get a reference to the GroupBox14 object and do soemthing like:
Worksheet("AppData").GroupBox14.Value := 2
But I can't figure out the proper syntax within code editor or help menu. I only have VB5 IDE installed, maybe I need VB6? I searched MS site and Google but cant find syntax as Excel has some ambiguous stuff.
How the heck can I do this? I will give MAX points for any help! Thanks!