A question regarding

[jobro]

So we're working on a pricelist that gives the end user a very easy way to lookup prices on the fly and get the money a customer needs to pay. So on sheet 1 we've got the items and the prices in their respective columns.

There is an userform aswell. In that form I've got a list linked to a the item names. That much is easy done. Now I've got in the same form a textbox that needs to be updated with the correct item chosen.

For this I've used the following code:

Me.Vara2.Text = Cells(lCrow + Vara1.ListIndex, 5).Value

that does give me an error that I'm using Me faulty.

Check the attachment xls file for more information.

Thanks in advance.

[royUK]

Welcome to the Forum.

You must read the Forum Rules & follow them, in this case your thread title needs editing. Click the link in my signature.

In addition, you must explain more thoroughly what you are doing. We need to know what kind of form, popup menu & textbox you are using.

[jobro]

Thanks, I'm on quite a speeded office. And hence I had no chance to alter it before I submitted the topic, so my bad on that one. I'll struggle to get better.

[royUK]

Which version of Excel are you using & why use a Dialog Sheet instead of a UserForm?

[jobro]

I'm using Excel 2003. No access to userforms AFAIK.

[royUK]

UserForms are standard and replaced Dialog Sheets. Open the VB Editor(Alt F11) and from the insert menu choose UserForm. You can then add the controls that you need.

Take a look at the example daatbase form here

http://www.excel-it.com/vba_examples.htm