Thanks Amber. I am going to look at your article too. The formula returns the
values okay, but if I change one of the values in a textbox, it still does
not update the sheet where the values are stored.

I changed the RowSource property of my ComboBox to 'Sheet1'!$A:$D and then
placed the following code in the Change event for the ComboBox:

Me.TextBox1.Value = Me.ComboBox1.Column(1)
Me.TextBox2.Value = Me.ComboBox1.Column(2)
Me.TextBox3.Value = Me.ComboBox1.Column(3)

Thanks again and I'll check out your article.
Eric

"Amber_D_Laws" wrote:


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