Control Source Updates in Userform

I have a userform with various textboxes with controlsource as formulas. e.g.

Please Login or Register  to view this content.

etc
There are many textboxes so I have set the controlsource programatically in the VBE.

I also have a ComboBox with the row source linked to a range in the spreadsheet. When I change the ComboBox selection Range("MySelection") changes to the offset for the each record. However the textboxes don't update!

Another thing, when I change the combobox the spreadsheet values don't update until I press enter. (Again it is linked with control source)

Two Questions:
1. How do I get the controlsource to refresh for each textbox automatically. (Do I have to reassign each value or is there a simpler way?)
2. How do I force the spreadsheet to update on a change of combobox without having to press enter.

Any help is appriciated greatly.

If you use ContolSource then the Textbox will refresh each time the relevant cell changes, but be aware, the reverse is true. Change a TextBox & the cell will change

Use the ComboBox Change event

Thanks! I think that's answered the second question but I'm still having trouble with the first. It works if I do this...

Please Login or Register  to view this content.

... but it is very slow. Is there a more efficient way of refreshing the controls?

Why not say what you are trying to do instead of what you think you need to do?

... to explain further:

I have a user form that I am using to update records in a database. The records are updated by overwriting the values in the textboxes.

I am trying to:
A. open userform2, select a record using the combobox1, update the values in the various textboxes and then
B. select another record and repeat the process... etc

So far I can sucsessfully edit the first record but when I try to edit subsequent ones I find that the textbox controlsources don't update when I select a new value with the combobox and I end up overwriting my previous record.

I wouldn't use ControlSource. Have a look at the DataBaseForm here

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

I had a look at databaseform.xls and I understand the principle but I'm not sure its quite what I need.

I was trying something which didn't require coding the relationships between the textboxes and the data columns for each parameter (I have 42 in total). The records are unique though, which makes things a little easier.

The beauty of controlsource is that it there is no update button to click and updates button and I can test solutions real time. (I also have calculation outputs on the form).

A better solution might be to have two seperate user forms one to select and one to edit. This works as when the form is reloaded the textbox controlsources automatically update.

There are various other complications: I have more than one source of data for some parameters and I want the user to be able to select the preferred source of data which would be updated to the master data record. Also for some data set the particular parameters are not relevant and their columns do not appear in the data sheet.