UserForm Listbox Trouble

[derekpax]

I have a UserForm where a person's name is selected and data is entered and stored in a database.

I want the UserForm to pre-load the data if the data has already been entered for a particular person.

After the name and corresponding data is found, I've been using:

ComboBox1.Value = ActiveCell.Value
TextBox1.Value = ActiveCell.Value

For ListBoxes I get the following error: "Could not set the Value property. Invalid property value."

The ListBox is not a multi-select ListBox

Any help would be appreciated

 

[BenRowe]

You should be using the AddItem method, e.g.:
ListBox1.AddItem (ActiveCell.Value)