Posted to microsoft.public.excel.programming

Bill

external usenet poster

Posts: 390

Display value linked to Combo Box Selection

Thanks Matt, this method worked perfectly for me.

"MattShoreson" wrote:

use a dynamic range to name the two columns, e.g. "countries"

then use

Sub comboBox1_Change()
with me

.comboBox2.value =
application.worksheetfunction.vlookup(.combobox1.v alue,countries,2,false)

end with
End Sub

--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=535571

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
Graph linked with combo boxes	Sasikiran	Excel Discussion (Misc queries)	2	March 12th 10 10:20 AM
Linked combo boxes	Nemo	New Users to Excel	2	July 18th 07 07:38 AM
Dependent (linked) combo boxes	shapiro	Excel Discussion (Misc queries)	3	April 26th 07 01:16 PM
Combo Box doesn't display text in linked cell	Broadband Al	Excel Programming	0	January 21st 06 05:49 PM
Linked Combo Boxes	LRobinson3	Excel Worksheet Functions	3	November 14th 05 01:35 PM

All times are GMT +1. The time now is 07:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us