Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is it possible to re-link a cell back to a combo box?
Good moring all, I am using a combo box that shows data using *ListFillRange*. This combo box is also using the *LinkedCell*, in which what ever is picked in the data it shows on a certain cell. Is it possible to pick that cell and re-link itself with the Combo Box? Thanks, Alp -- AlP ------------------------------------------------------------------------ AlP's Profile: http://www.excelforum.com/member.php...o&userid=18390 View this thread: http://www.excelforum.com/showthread...hreadid=346805 |
#2
|
|||
|
|||
If that combobox has a *Style* of fmStyleDropDownCombo, then it seems to do that
already. But if you use a *Style* of fmStyleDropDownList, it only works if you choose a valid entry from that *ListFillRange*. I think that's what you were asking.... AlP wrote: Good moring all, I am using a combo box that shows data using *ListFillRange*. This combo box is also using the *LinkedCell*, in which what ever is picked in the data it shows on a certain cell. Is it possible to pick that cell and re-link itself with the Combo Box? Thanks, Alp -- AlP ------------------------------------------------------------------------ AlP's Profile: http://www.excelforum.com/member.php...o&userid=18390 View this thread: http://www.excelforum.com/showthread...hreadid=346805 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
How do I autofill combo boxes with their destination cell? | Excel Worksheet Functions | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |