My ComboBox Text selections have a value of '0'

Hi, probably a very simple one here but I cant work it out.

I have a combobox with contains around 15 different words. I want a user to select a word and then this word will be included in another macro.

Problem being the result is always Zero and not the actual text from within the combobox

Can anyone help me out?

Thanks

SF

Re: My ComboBox Text selections have a value of '0'

The combobox is located on my first sheet. The words which populate it are from a range on my 2nd sheet. I done this by double clicking the box, then via the Control Tab I selected the range from sheet 2.

Theres only one column.

Tks

Re: My ComboBox Text selections have a value of '0'

Norie

Its a forms combobox.

The actual value is wrong before I can even use it in a macro.

Also, I've made a mistake in my post...the result is not always '0'

Word No1 = gives a result of '1' in the linked cell
Word No2 = gives a result of '2' in the linked cell
Word No3 = gives a result of '3' in the linked cell so on and so on etc etc....

I just want the linked cell to show the actual text rather than a number.

I can go around the houses by adding something like the following in a macro but its not ideal.

If result = 1 then let word = "hello"

tks

Re: My ComboBox Text selections have a value of '0'

I can, but would like to use this method as uses will be required to add items. This way seems quick and easy.

Surely the text value of a combobox can be repeated in the linked cell.

Anybody?

Re: My ComboBox Text selections have a value of '0'

ok, tks I will give it a go.

Regards