Excel Displaying Derived Data in an Excel Userform

Joined
Apr 19, 2007
Messages
3
Reaction score
0
20/04/07 Please see below.

I have a Userform which collects a Product identity and other information which is all stored correctly in the spreadsheet it supports. I need to break into the Userform after Product is entered, to find the product in a separate spreadsheet (it will be there) and retrieve its price, which I then want to display in a new text box on the userform.

I have everything else working, but I cannot find a way to get the price data to appear, before going on to enter the remaining fields. I have set ControlSource for the price field = to its cell address, and I have confirmed that it is there. I have tried reissuing Form.Show but this causes an error, and Form.(next) Item.SetFocus but this seems to have no effect.

Any help will be very gratefully received.

20/04/07

I have solved the problem - part an error on my part and part more experiment and learning. I apologise to those of you whose time I have wasted.
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top