Combo Box

[Neil Pearce]

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

 

[T. Valko]

A combo box from the Forms toolbar will return the index number to the
linked cell.

 

[Neil Pearce]

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]

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)

 

[Neil Pearce]

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]

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!