ListBox-insert text from cell

[The Dutchman]

I am working on a userform where a client's profile can be edited. A client's name is selected and then a number of textboxes and listboxes are automatically populated from the information from that client last record on file.

There are 3 listboxes in the userform that are populated from 3 different cell ranges when the userform is activated.

When I attempted to populate the listbox (which was populated already at activation) with the text/value from a clients record I get the following message:

"Could not set the text property. Invalid propert value."

Just an FYI... the value/text from the cell I'm pulling data and pushing to the various ListBoxes corresponds with data that are in the listboxes when they are populated when the userform is activated.

The code I used is as follows:

Me.ListBox1.Text = Range(caddress).Offset(0, 23).Value
Me.ListBox2.Text = Range(caddress).Offset(0, 13).Value
Me.ListBox3.Text = Range(caddress).Offset(0, 14).Value
 
'*** AS WELL I TRIED ****
 
Me.ListBox1.Value = Range(caddress).Offset(0, 23).Value
Me.ListBox2.Value = Range(caddress).Offset(0, 13).Value
Me.ListBox3.Value = Range(caddress).Offset(0, 14).Value

Any ideas out there?

 

[doofusboy]

Have you tried:

Me.ListBox1.Add = Range(caddress).Offset(0, 23).Value
Me.ListBox2.Add = Range(caddress).Offset(0, 13).Value
Me.ListBox3.Add = Range(caddress).Offset(0, 14).Value

 

[The Dutchman]

Thanks for taking the time to respomd to my query.

I just tried your suggestion and it came up with a the following message:

"Method or data Memeber not Found"

Looking at the ".Add" would that potentially add items to the lisbox? All I want to do is have the listbox show the item that was choosen the last time that record was either created or when it was last edited.

Any other ideas?

Ray

 

[Norie]

Ray

This is from Help.

For a ListBox, the value of Text must match an existing list entry. Specifying a value that does not match an existing list entry causes an error.

And there is no Add method/property/whatever for listboxes.

I've read your original post a number of times but I still don't understand what you are actually trying to do, probably me though.

First you say you've populated 3 listboxes with data from a range of cells, so supposedly they would have multiple entries.

Then you seem to be saying you want to populate the listboxes with an individual entry.

 

[The Dutchman]

Thanks for you curiosity Norie:

Here is what I am trying to accomplish.

A client profile is first created. When this "Create Client Profile" userbox1 is activate items for 3 listboxes are added. When complete, the profile is saved (let's say to row 10).

Now when you want to edit that same profile, you go into userform2 "Edit a Client Profile". When activated items are added to 4 listboxes (the extra one being the client list which was not in the previous userform).

When in the Edit Client Profile" userform, the first thing you do is choose a client from a lisbox. When this listbox is updated data from row 10 is then placed in the respective textboxes as well, I'm trying to populate the listboxes from the correrponding data that was originally saved in row 10.

If the person so choose the change the items listed in the 3 listboxes for that company he/she can do so... but when the record is first brought up the previous choice is shown.

I hope this helps you understand what I'm trying to accomplish and find a solution.

Ray