HHHEEELLLLLLLPPPPP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ??????
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combing values from 2 Comboboxes into 1 cell 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
entering time values 1
Query Parameter using multiple options 0
Problem Using Delete Key Because of Combobox 11
ComboxBox with Dynamically Defined Source, and LinkedCell error 1
Excel VBA - Problem with Closing Print Preview 0
Creating a named range? 2

Back
Top