formula disappears after being displayed in userform listbox

[simeonmein]

Hi all
In cell g22 and cell i3 I have 2 basic formulas, problem is, everytime the formula is activated and changed in the listbox, the value remains in both cells, but the formula dissepears. I have scanned through my code and there is no .value assigned to either listboxes. In both cases I tested using the rowsource property and using code. Please can someone help?

[Izandol]

It is not clear what you are doing exactly but if you have linked a listbox to a cell the formula will be overwritten by the value and you may not avoid that unless you unlink them.

[simeonmein]

Yes, that's exactly my problem, how do I unlink them? It use to work just fine, its really baffeling me.

[Izandol]

Clear the Rowsource and Controlsource properties of the control.

[simeonmein]

I have tried that, problem is, it also does the same when I enter code under userform initialize that links the cell to the listbox, tried a textbox also and same result. After the formula is activated, the result remains but not the formula.

[Izandol]

Naturally the effect is the same. Do not link the control to the cell. Rather populate both in your code using the Value (or Text) properties instead.

[simeonmein]

Like this?

Please Login or Register  to view this content.

[Izandol]

I do not know - I can not see your form. I do not understand why you use a listbox for one value.

[simeonmein]

Its like a calculator screen, but after the first formula, the listbox only shows the value and won't add anything else.

[Izandol]

If you can not provide a workbook or all of the code I cannot know what is happening nor why.

[simeonmein]

So I removed the textbox and made it a listbox, problem solved