ExcelBanter - I have an msoControlEdit which I need to fix the text typed into i

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - I have an msoControlEdit which I need to fix the text typed into i (https://www.excelbanter.com/excel-programming/369767-i-have-msocontroledit-i-need-fix-text-typed-into-i.html)

Padam

I have an msoControlEdit which I need to fix the text typed into i

Excel 2000 (Using VBA)
--------------
I have an msoControlEdit which I need to fixthe text typed into it. When I
type the text and press my OK button the text I typed in the msoControlEdit
vanished.

I noticed it can be achieved by pressing enter/tab, but is there a way to
fix the text immediately? Also can it be made to look like a password field?

All times are GMT +1. The time now is 10:07 PM.