Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
AlP
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I copy a combo box in Excel 2002 with a relative cell link? Bozo Excel Discussion (Misc queries) 1 February 17th 05 02:05 AM
How do I autofill combo boxes with their destination cell? Defoes Right Boot Excel Worksheet Functions 3 January 10th 05 12:49 PM
How do I link many cells to one particular cell? fish@divi Excel Discussion (Misc queries) 2 January 4th 05 11:00 PM
How do I link many cells to one particular cell? justinfishman22 Excel Discussion (Misc queries) 2 January 4th 05 12:09 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"