ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problems with cell-binded textbox (https://www.excelbanter.com/excel-programming/423048-problems-cell-binded-textbox.html)

don H. Lee

Problems with cell-binded textbox
 
Hi newsgroup

I already posted this on the german newsgroup but I didn't get the needed
answers so I try again in english.

I have the following problem:

I am using Excel 2000, WinXp, Swiss-German settings
I have a form where a textbox is placed. This textbox has a controlsource to
a cell ("Mysheet:h3"). The Format of the cell "h3" is general (don't think
that this really matter).

No I start the form an try to put "18.5" into the textbox. When exit the
value changes to 399... I changed the format of the cell and put it to
number but didn't work.

How can I handle this?

Any ideas?

Thanks alot and best regards

D.H. Lee



dan dungan

Problems with cell-binded textbox
 

Hi D.H. Lee

Try changing the format of the textbox in properties.

Dan




All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com