| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box
All,
In design mode I have created a combo box. I have inputted the 'ListFillRange' & 'LinkedCell'. However when I select an input from the croll bar the link cell doesn't place a ref nr but the text of the selected input instead! Any ideas how to change this? Cheers, Neil |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combo Box
A combo box from the Forms toolbar will return the index number to the
linked cell. -- Biff Microsoft Excel MVP "Neil Pearce" wrote in message ... All, In design mode I have created a combo box. I have inputted the 'ListFillRange' & 'LinkedCell'. However when I select an input from the croll bar the link cell doesn't place a ref nr but the text of the selected input instead! Any ideas how to change this? Cheers, Neil |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combo Box
Thank-you. I realise this but unfortunately have to create my own so that I
can increase the font size in the box: the forms box's font is too small. Any ideas how to change the link box from text to a reference umber as expected? Cheers, Neil "T. Valko" wrote: A combo box from the Forms toolbar will return the index number to the linked cell. -- Biff Microsoft Excel MVP "Neil Pearce" wrote in message ... All, In design mode I have created a combo box. I have inputted the 'ListFillRange' & 'LinkedCell'. However when I select an input from the croll bar the link cell doesn't place a ref nr but the text of the selected input instead! Any ideas how to change this? Cheers, Neil |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combo Box
I'm not sure how you'd do it programmatically (VBA) but you could use
another cell with a simple MATCH formula. A1 = linked cell B1:B10 = combo box source (ListFillRange) =MATCH(A1,B1:B10,0) -- Biff Microsoft Excel MVP "Neil Pearce" wrote in message ... Thank-you. I realise this but unfortunately have to create my own so that I can increase the font size in the box: the forms box's font is too small. Any ideas how to change the link box from text to a reference umber as expected? Cheers, Neil "T. Valko" wrote: A combo box from the Forms toolbar will return the index number to the linked cell. -- Biff Microsoft Excel MVP "Neil Pearce" wrote in message ... All, In design mode I have created a combo box. I have inputted the 'ListFillRange' & 'LinkedCell'. However when I select an input from the croll bar the link cell doesn't place a ref nr but the text of the selected input instead! Any ideas how to change this? Cheers, Neil |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combo Box
That worked brilliantly. Thank-you very much indeed. Any chance you could
have a llok at my earlier question regarding "lock cells"? Your in great appreciation, Neil "T. Valko" wrote: I'm not sure how you'd do it programmatically (VBA) but you could use another cell with a simple MATCH formula. A1 = linked cell B1:B10 = combo box source (ListFillRange) =MATCH(A1,B1:B10,0) -- Biff Microsoft Excel MVP "Neil Pearce" wrote in message ... Thank-you. I realise this but unfortunately have to create my own so that I can increase the font size in the box: the forms box's font is too small. Any ideas how to change the link box from text to a reference umber as expected? Cheers, Neil "T. Valko" wrote: A combo box from the Forms toolbar will return the index number to the linked cell. -- Biff Microsoft Excel MVP "Neil Pearce" wrote in message ... All, In design mode I have created a combo box. I have inputted the 'ListFillRange' & 'LinkedCell'. However when I select an input from the croll bar the link cell doesn't place a ref nr but the text of the selected input instead! Any ideas how to change this? Cheers, Neil |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combo Box
You're welcome. Thanks for the feedback!
Any chance you could have a llok at my earlier question regarding "lock cells"? I see you have replies at that post. You're in good hands with Gord! -- Biff Microsoft Excel MVP "Neil Pearce" wrote in message ... That worked brilliantly. Thank-you very much indeed. Any chance you could have a llok at my earlier question regarding "lock cells"? Your in great appreciation, Neil "T. Valko" wrote: I'm not sure how you'd do it programmatically (VBA) but you could use another cell with a simple MATCH formula. A1 = linked cell B1:B10 = combo box source (ListFillRange) =MATCH(A1,B1:B10,0) -- Biff Microsoft Excel MVP "Neil Pearce" wrote in message ... Thank-you. I realise this but unfortunately have to create my own so that I can increase the font size in the box: the forms box's font is too small. Any ideas how to change the link box from text to a reference umber as expected? Cheers, Neil "T. Valko" wrote: A combo box from the Forms toolbar will return the index number to the linked cell. -- Biff Microsoft Excel MVP "Neil Pearce" wrote in message ... All, In design mode I have created a combo box. I have inputted the 'ListFillRange' & 'LinkedCell'. However when I select an input from the croll bar the link cell doesn't place a ref nr but the text of the selected input instead! Any ideas how to change this? Cheers, Neil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
| combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
| Can one combo box control the data in a different combo box | Excel Discussion (Misc queries) | |||
| "Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
| "Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
Linear Mode
