HELP: Sheet embedded comboboxes

[Clinton M James]

Hi all,

I am assisting somebody with their excel project and they have a sheet with
comboboxes in it.

When a value is selected, it populates cells underneath, however when the
data is freshly loaded, the cell underneath is given the value but the
combobox does not update to this value.

I have tried to click on the box to edit it, however no matter how many
times i click i cannot seem to get it to recognise i've clicked. In other
words, the resizing box does not come up and i have no right-click menu.

All i can do is select from the drop down list without any editing of the
properties.

Does anybody know how i can get into this combobox and how i would make it
display a value?

I have tried referencing it directly with the .value property but i get an
error.

Thank you in advance for any assistance.

Cheers,
Clint

 

[David Heaton]

Hi all,

I am assisting somebody with their excel project and they have a sheet with
comboboxes in it.

When a value is selected, it populates cells underneath, however when the
data is freshly loaded, the cell underneath is given the value but the
combobox does not update to this value.

I have tried to click on the box to edit it, however no matter how many
times i click i cannot seem to get it to recognise i've clicked. In other
words, the resizing box does not come up and i have no right-click menu.

All i can do is select from the drop down list without any editing of the
properties.

Does anybody know how i can get into this combobox and how i would make it
display a value?

I have tried referencing it directly with the .value property but i get an
error.

Thank you in advance for any assistance.

Cheers,
Clint

Clint,

It soulds like a ActiveX combo box. Make sure the Visual Basic
toolbar is visible then click the click on the Design Mode button.

Regards

David