Userform textbox used as refedit

Jacques Grobler,

Goeie more,

Could you upload a small sample WorkBook with Userform etc. also showing on a seperate sheet the desired outcome?

Maybe it will clear things up for us.

'n Goeie more aan jou ook Winon

I have picked up a couple of problems while trying to replicate what I'd like to achieve:

1> When I enter a formula into a refedit box, excel hangs
2> When I enter a value into the refedit box, and want to get the value, as it is not a range value, it errors - this I can sort out, least of my problems

I have attached a workbook with 2 forms in, note that only one form is called form the excel workbook, the other needs to be run from VBE directly (not connected to anything at this stage).

I hope this gives a better idea of what I'd like to achieve, if not, please let me know.myBook_btns Control.xlsm

Somebody... Anybody... Nobody... Body...

Hi Jacques,

Gestonk!

Sorry, but I cannot give you a solution as yet. As far as the RefEdit goes, I don't think it will ever allow a user to enter any number or formula in there. I will have a look at it again later tonight.

In the meantime, I think you should replace those two boxes with TextBoxes.

Sterkte!