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 |
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 |
All times are GMT +1. The time now is 06:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com