Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change cell link in combox box dynamically | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |