ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is it possible to re-link a cell back to a combo box? (https://www.excelbanter.com/excel-discussion-misc-queries/13879-possible-re-link-cell-back-combo-box.html)

AlP

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


Dave Peterson

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