Controlsource: keep cell formatting

Hey All

I am losing my sanity haha!!!

It seems so simple but I cannot for the life of me find a solution. I have a textbox on a userform that is linked via controlsource to a cell on sheet1 - call it A1. A1 is simply a sum of values (which constantly changes) and it is formatted as currency. All I would like is to carry over range("A1").text to my textbox so that it keeps the currency formatting.

Why does this seem so impossible? All I want is something like the controlsource property to be A1.text, not just A1 where I get a value.

Thanks!

Thanks Norie. Well at least I'm not mad. I appreciate your response, but I need this textbox to update whenever the source cell changes. A worksheet change just seems a bit unnecessary for something which in my mind is so darn simple..

Well I'd like the textbox/label (I chose textbox because I figured controlsource was the most reasonable option) to constantly update with A1. A1 is a sum of hundreds of costs.

So I'd like a label/textbox to update on the userform as the user selects different options. Which is all good with controlsource but I can't keep the currency formatting...

Obviously this label/textbox won't be available for edit by the user.

Thanks Norie!

The userform lets you choose options like type/quantity/etc through optionbuttons and checkboxes, the results are posted to a worksheet where the final price is calculated - but it is a fairly complex procedure and simple options can have huge effects on the final price.

The label is very useful for keeping track of the changes to price according to the options you choose.

You choose a product which is a commandbutton - this opens a userform where you can further specify product options. The worksheet recalculates whenever an option is chosen/edited, and the final price after markup etc is displayed in A1. A textbox with a controlsource to A1 works perfectly but as you say you lose the formatting..

Temp.jpg

Ok so the price summary is actually in B7, and the textbox displays that figure at the bottom of the userform

I'm afraid I can't too much sensitive information!

Anyway, thanks for your time Norie, I have just linked a label to the range.text on a worksheet change event, and that seems to be working ok Have I misunderstood sourcecontrol? I'm now noticing that the textbox fixes B7 but I'm not sure if I have done something strange to cause that.