activeX

[littleme]

Hello!

Hava a wee mac problem it seems. Since mac doesnt support activeX im
at a bit of a loss. So if someone could help me id be very grateful...

Would like users to be able to have something like a combo box that
allows users to choose from a list of headers, and then for that word
to appear in the cell that is selected in column B. Dont necessarily
need to use combo boxes, but verfication/ drop down is not appropriate
here. They need to be able to choose and insert header where they find
it apporpriate in theire list....

please!!!

 

[JE McGimpsey]

Hava a wee mac problem it seems. Since mac doesnt support activeX im
at a bit of a loss. So if someone could help me id be very grateful...

Would like users to be able to have something like a combo box that
allows users to choose from a list of headers, and then for that word
to appear in the cell that is selected in column B. Dont necessarily
need to use combo boxes, but verfication/ drop down is not appropriate
here. They need to be able to choose and insert header where they find
it apporpriate in theire list....

This is easily done with Forms Toolbar controls (View/Toolbars/Forms).
Here's the way I typically do it. This could be simplified, but I use
named ranges to make it more flexible.

On another sheet, named, say, "Lists" (which I subsequently hide), I put
the list name in A1, then the list in A3:Ax:

A
1 Colors
2
3 Red
4 Green
5 Blue


Since I may want to add to the list, I create a dynamic range called
"Colors", using Insert/Name/Define:

Names in Workbook: Colors
Refers to: =OFFSET('Lists'!$A$3,0,0,COUNTA('Lists'!$A$3:$A$100),1)

which will allow the list to automatically grow or shrink as I add or
subtract items.

I also name Lists!$A$2, say, "Colors_Index"

Back in my working sheet, I insert a Combobox from the Forms toolbar. I
CTRL-click the combobox and select Format Control. In the Control tab, I
enter

Input range: Colors
Cell link: Colors_Index

Then in the cell in column B that I want to see the results in, I enter

=INDEX(Colors,Colors_Index)

Now when I select Green from the combobox, Lists!A2 receives the value
2, and the column B cell returns "Green"

 

[littleme]

Hi!

Thank you for the tip! It works fine, and its good to know, except
theres a small problem. I propably wasnt too clear in my original
thread. the thing is that this was to apply to an entire column. So
when I copy-paste the index formula the length of the column, they all
change to the same header.... Once a word is chosen from the combo
box, I need it to stay... So in H4 it should be able to choose Green,
and in H7 Blue, as it is now, both say whatever I chose last. Second
problem is that the word should only appear in specific cells, rather
than the entire column. Cells should be bland until a colour from the
combo is chosen, and fills in that specific cell, because they are
mean to work as headers. Underneath Blue, they should be able to type,
blueberry, eggplant...etc And then sometimes they may change their
mind, and where it once said eggplant, they want a header Red from the
combo... Do you get what i mean?

Can you help me?