Combo Box cell link - return exact "text" in combobox instead of number

**adamsj1** · 10-08-2014, 04:34 AM

Dear All,

I have a basic question about combobox. I want the cell link to return a text instead of a number.

Attached excel explaining what I am trying to do.

Thank you very much.

**karedog** · 10-08-2014, 05:56 AM

Hi,

You should use the activex 's combobox, not form's combobox.

Look here here for the explanation, in "Add a combo box (ActiveX control)" section.

Combo Box cell link - return exact "text" in combobox instead of number

LinkBack

Thread Tools

Rate This Thread

Display

Combo Box cell link - return exact "text" in combobox instead of number

Re: Combo Box cell link - return exact "text" in combobox instead of number

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Combo list selected by "contains" text string entered rather than "begins with"

[SOLVED] If "text" then return "number" and/or different "text"

[SOLVED] How to link a cell, with date formula, to another cell if it will return to "#value!"?

[SOLVED] Find multiple "text" criteria and return as ""Yes" in Matrix

[SOLVED] macro for converting number stored as "text" (or preceeded with ') to "number" formatting

Bookmarks

Bookmarks

Posting Permissions