Assigning a value to a cell from a combox
 

Hi all,

I have a 2 combobox and a button in my work sheet

On click of this button,
*the values in combobox must be assigned to a cell*
(assume h8 and h9).

can any one please help me to solve this problem.


--
sjayar
------------------------------------------------------------------------
sjayar's Profile: http://www.excelforum.com/member.php...o&userid=28435
View this thread: http://www.excelforum.com/showthread...hreadid=480977

Assigning a value to a cell from a combox
 

Good morning sjayar

It really depends on how you have set up your combo box and button. If
you have done it through the control toolbox use this code attached to
your button (double click on the button to open up the code window).

Range("H8").Value = ComboBox1.Value
Range("H9").Value = ComboBox2.Value

If you are doing it through the forms toolbar then you're making life a
bit more difficult for yourself because I think that this can be set to
return only the position of your selection (ie., 1,2,3 etc) but not the
actual combobox value. To set this, right click and select Format
Control, Control and enter a cell in the cell link box. You would then
need to use a lookuptable or something to find out the value.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=480977

Assigning a value to a cell from a combox
 

hi ,
thank u very much .
it worked.
lots and lots of thanks to you.


--
sjayar
------------------------------------------------------------------------
sjayar's Profile: http://www.excelforum.com/member.php...o&userid=28435
View this thread: http://www.excelforum.com/showthread...hreadid=480977

Assigning a value to a cell from a combox
 

Hi sjayar

You're welcome. Appreciate the feedback.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=480977