Hello Eric,

I am currently dealing with a similar problem. If the comments left in
this tread are not helpful to you, than perhaps taking a look at what
Tom has suggested to me will be of some use.

See:
http://www.excelforum.com/showthread.php?t=513312

I am trying to use an index/match formula.

See ya',
Amber :)


Eric Wrote:
Hello there, I have a UserForm on which there is 1 ComboBox (ComboBox1)
and 3
TextBoxes (Textboxes 1,2,3). The values for ComboBox1 and the TextBoxes
are
stored in multiple columns on a sheet within the workbook. (Sheet1)
(Columns
A,B,C,D) What I would like to do is this: When a user selects a value
from
ComboBox1 (Gathered from Column A), I would like the Textboxes to
automatically fill in based upon the values from Columns B,C, and D
respectively. That is part one.

Part two, If the information gathered needs to be changed, I would like
the
user to be able to change it in the Textbox and have the values
automatically
update on the sheet. Any help would really be appreciated.


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=513328