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

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

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

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

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

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