Hi,
I have grouped a couple of activeX combobox controls (the groupname is 'piechartgroup').
I am trying to use VB to change the value property of 'combobox1' (the default name given by the VB editor when that particular combobox was created but am running into problems.
The following code attempts didn't work:
Can anyone indicate the required code to access a particular Activex control which is part of a group?![]()
'Effort 1- trying to directly access the control: Activesheet.shapes("combobox1").value="Hello" 'Effort 2:- trying to access the control via the group Activesheet.shapes("piechartgroup").shapes("combobox1").value="Hello" 'Effort 3- using the groupitems approach Activesheet.shapes("piechartgroup").groupitems("combobox1").value="Hello"
Thanks in advance,
Brian
Bookmarks