How do I get a combo box to return values not numbers. My combo box displays January - February, but my linked cell only displays 1-12. How do i get what is actually in the combo box to appear in the linked cell.
I have searched for hours for a solution to this - any help would be great!
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
Thanks Biff, I followed those instructions, and after I entered the formula in A1 it did indeed display the text from the Combo Box - bingo! But then when I changed the combo box selection it wasn't updated in A1 (the number was being updated in the linked cell though when I took a peek). Any suggestions?
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
I must be making some fundamental error.
Using Choose (d6,j1,j2,j3,j4......) the combo box text was reflected in the desired cell, but when a further option was selected the cell did not update with the text (the linked cell did however update its number).
When I tried to use the number generated in the linked cell to return the actual item from the input range (using IF formula) it did not work.
What am I doing wrong? I am a noddy.
i am sure it is a basic error - what is it!?
true thanks to the savior!
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
I think I know what I am doing wrong. I am just inserting a combobox, right clicking it and inserting the range and linked cell into the prompt boxes.
But in fact do I need to write a macro to make this work?
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Hi!
It should work. There isn't that much that can "go wrong"!
If you want, you can send the file to me and I'll take a look. If you want
to do that let me know how to contact you.
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> i am sure it is a basic error - what is it!?
>
> true thanks to the savior!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
i ussually put my linked cell at the bottom of my range,I like biffs idea
tho...to show your month you can also use Choose(d6,j1,j2,j3,j4......)The
referencing of the combo box is right at the end of the forms combobox help
Combo box A drop-down list box. The item that is selected in the list box
appears in the text box.
Combo box properties
Input range Reference to the range containing the values to display in
the drop-down list.
Cell link Returns the number of the item that's selected in the combo box
(the first item in the list is 1). You can use this number in a formula or
macro to return the actual item from the input range.
For example, if a combo box is linked to cell C1 and the input range for the
list is D10:D15, the following formula returns the value from range D10:D15
based on the selection in the list:
=INDEX(D10:D15,C1)
--
paul
remove nospam for email addy!
"Biff" wrote:
> Hi!
>
> Put the linked cell "behind" the combo box. Then use a formula to reference
> that linked cell.
>
> Assume you have the months listed in the range J1:J12 as the source (input
> range) and you want the selection from the combo box to appear in cell A1.
> The combo box covers cell D6 so make cell D6 the linked cell. Then use a
> formula like this in A1:
>
> =INDEX(J1:J12,D6)
>
> Biff
>
> "Doyle Brunson" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > How do I get a combo box to return values not numbers. My combo box
> > displays January - February, but my linked cell only displays 1-12. How
> > do i get what is actually in the combo box to appear in the linked
> > cell.
> >
> > I have searched for hours for a solution to this - any help would be
> > great!
> >
> >
> > --
> > Doyle Brunson
> > ------------------------------------------------------------------------
> > Doyle Brunson's Profile:
> > http://www.excelforum.com/member.php...o&userid=19235
> > View this thread: http://www.excelforum.com/showthread...hreadid=394114
> >
>
>
>
You could use a dynamic name for the source range, instead of a cell
reference. This would grow automatically as new items are added. There
are instructions here:
http://www.contextures.com/xlNames01.html
If you use a combo box from the Forms toolbar it will return numbers. If
you use a combo box from the Control toolbox, it will return the
selected item.
Doyle Brunson wrote:
> I think I know what I am doing wrong. I am just inserting a combobox,
> right clicking it and inserting the range and linked cell into the
> prompt boxes.
>
> But in fact do I need to write a macro to make this work?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Hi!
Put the linked cell "behind" the combo box. Then use a formula to reference
that linked cell.
Assume you have the months listed in the range J1:J12 as the source (input
range) and you want the selection from the combo box to appear in cell A1.
The combo box covers cell D6 so make cell D6 the linked cell. Then use a
formula like this in A1:
=INDEX(J1:J12,D6)
Biff
"Doyle Brunson" <[email protected]>
wrote in message
news:[email protected]...
>
> How do I get a combo box to return values not numbers. My combo box
> displays January - February, but my linked cell only displays 1-12. How
> do i get what is actually in the combo box to appear in the linked
> cell.
>
> I have searched for hours for a solution to this - any help would be
> great!
>
>
> --
> Doyle Brunson
> ------------------------------------------------------------------------
> Doyle Brunson's Profile:
> http://www.excelforum.com/member.php...o&userid=19235
> View this thread: http://www.excelforum.com/showthread...hreadid=394114
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks