arich

Posts: n/a

Combo Box

I want both the code and corresponding English translation to appear in the
dropdown box. The codes are in col A, and the translations are in col B.
Under Properites, ListFillRange I have entered: Jobs!A2:B200. Only column A
is shown in the dropdown box. Also, when I select one of the dropdown options
I get a VB error with my "Jobs!A2:B200" displayed in the VB code. Please tell
me what I'm doing wrong. Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nesting Combo Boxes /Returning an Array	ELMONDO SNITHER	Excel Discussion (Misc queries)	1	June 30th 05 01:15 AM
Dynamic Combo Box	benjarfer	Excel Worksheet Functions	2	April 8th 05 02:17 PM
connecting combo boxes to yield data in another cell.	TxN8tv	Excel Discussion (Misc queries)	0	March 14th 05 04:07 PM
extract data from combo box n use it in SQL	benj	Excel Discussion (Misc queries)	2	February 16th 05 09:54 AM
dynamic combo boxes	tjb	Excel Worksheet Functions	2	January 25th 05 07:33 PM

All times are GMT +1. The time now is 06:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us