Struggling with List Box

[Sue]

Hi

I have a List Box populated by Rowsource A3:I600 -I need to renew
information in Columns J :Q whilst viewing the list Box on the UserForm. I
would theefore see in the Textboxes all the data A3:I3 -- I can then fill the
TextBoxes for Columns J:Q click the CommandButton and the data is on the
Sheet. My problem is if I select in the ListBox A90:I90 when I input the data
in the TextBoxes for Columns J:Q its on Row4 instead of Row90. how do I
resolve this problem?

 

[Nigel]

I think you need to help me a bit understand your problem. Are you saying
depending on the row selected in the ListBox where rowsource is A3:I600 you
want values in other textboxes transferred to the same row number?

 

[Sue]

Hi Nigel

In the ListBox I select J. Bloggs who is on Row3 the UserForm then displays
in several TextBoxes all his info address - phone etc. there are then
TextBoxes for more info such as Renewal date - Subs etc which are empty I put
the info in these TextBoxes and it all goes into the Sheet on Row3 - Columns
J:Q.

My problem is selecting J. Smith on Row 90 in the ListBox I view all his
info in the UserForm address - phone etc -- fill in the other TextBoxes click
CommandButton and instead of being in Row90 its in Row4 against another
members name.

Does that explain my problem???




--
Many Thanks

Sue

I think you need to help me a bit understand your problem. Are you saying
depending on the row selected in the ListBox where rowsource is A3:I600 you
want values in other textboxes transferred to the same row number?



--

Regards,
Nigel
(e-mail address removed)

 

[Nigel]

You need to post the code from the UserForm so a solution can be offered.
It appears the other controls are being set to the relevant row as you
select a new name. So I am not sure why the boxes you are editing are also
not pointing to that row.



--

Regards,
Nigel
(e-mail address removed)

Hi Nigel

In the ListBox I select J. Bloggs who is on Row3 the UserForm then
displays
in several TextBoxes all his info address - phone etc. there are then
TextBoxes for more info such as Renewal date - Subs etc which are empty I
put
the info in these TextBoxes and it all goes into the Sheet on Row3 -
Columns
J:Q.

My problem is selecting J. Smith on Row 90 in the ListBox I view all his
info in the UserForm address - phone etc -- fill in the other TextBoxes
click
CommandButton and instead of being in Row90 its in Row4 against another
members name.

Does that explain my problem???

 

[john]

Sue,
as a thought, rather than use a custom form would the built in form > Data >
Form
not meet your needs? if not, Nigels suggestion of posting your code would be
best way for community to assist you further.

 

[Sue]

Hi You Guys

What a great suggestion didn't even know how to get the data form properly
in 2007 eventually found it -- thank goodness -- problem solved thank you.