HHHEEELLLLLLLPPPPP
 

Hello any help please??
Im sure its very easy but i just cant figure it out.

I have a comboBox from toolbar, in this comboBox i have some options the
user can select. I want the option that the user selected from the combobox
to when selected have it appear in a cell B:31
What do I type in cell B:31 in order to read the value of the combobox

Would I type cell B:31

=ComboBox1.Value ??????

HHHEEELLLLLLLPPPPP
 

If you've used the ComboBox from the Control Toolbox:
use View | Toolbars to bring that toolbox back into view, then click the
upper left icon to put yourself into design mode, if not already in it when
you open that toolbar. Right-click on your combo box and select properties -
look down the list of properties to find the 'Linked Cell' entry. Put B31
into that property. Get out of design mode. Now any choice you make from
the combo box will appear in B31.

Note: to toggle design mode there is an icon at the upper left of the
Control Toolbox toolbar that looks like a blue triangle, yellow pencil and
yellow ruler that you click on. It toggles in/out of design mode.

"N.F" wrote:

Hello any help please??
Im sure its very easy but i just cant figure it out.

I have a comboBox from toolbar, in this comboBox i have some options the
user can select. I want the option that the user selected from the combobox
to when selected have it appear in a cell B:31
What do I type in cell B:31 in order to read the value of the combobox

Would I type cell B:31

=ComboBox1.Value ??????

HHHEEELLLLLLLPPPPP
 

Hi,

Refer to this url: http://www.contextures.com

Challa Prabhu

"N.F" wrote:

Hello any help please??
Im sure its very easy but i just cant figure it out.

I have a comboBox from toolbar, in this comboBox i have some options the
user can select. I want the option that the user selected from the combobox
to when selected have it appear in a cell B:31
What do I type in cell B:31 in order to read the value of the combobox

Would I type cell B:31

=ComboBox1.Value ??????