Hi,

I hope there is someone who can help me solve a problem.

I have a database sheet in excel called "datadga"

I have a userform on which i have a multipage object with a lot of text
boxes and comboboxes.
The use chooses an item from a dropdownlist on the multipage object and all
data of this particular item is retreived form the database sheet.
This works fine with textboxes, even if de database sheet does not have an
entry for this specific textbox. It leaves the textbox empty.

However, when i try to fill a combobox with teh value from a cell in the
database, it only works if there is a value present in that particular cell.
Otherwise i get an error for that particular combobox.

My question: How can i get rid of the error and let the program continue.
The combobox thould the have no value.

I now have the following code;

when a button is clicked, alle fields on the multipage object are filled
with data from the data sheet in the following way;

txt_opnpnapd1 = Worksheets("datadga").Cells(klantmatrix.Row,
klantmatrix.Column + 75)
cbo_opnpnapd1 = Worksheets("datadga").Cells(klantmatrix.Row,
klantmatrix.Column + 76)
etc..(over 120 fields)

This works fine for both textbox and combobox as long as the cells in
"klantmatrix" are all filled.
When a cell is empty, the combobox presents an error and the program stops.

Please help me so i can move on with the application.

Pierre