| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the textbox value without changing the textbox format?
Hello,
I have a userform with text boxes and I assign values from cells like below: UserForm1.TextBox1.value = Sheets("Calculation").Range("A1").value UserForm1.TextBox1.text = Sheets("Calculation").Range("A1").text However when I change the code later to something like this: UserForm1.TextBox1.value = Sheets("Calculation").Range("B1").value Not only is the value updated/changed but the format is gone also. How can I set the format/text only one time (on activate of userform for example) so that I don't need to set the format everytime? Thank you, Ozgur |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing textbox properties from Access VBA | Charts and Charting in Excel | |||
| ActiveX textBox : value doesn't show after programatically changing the value | Excel Programming | |||
| Changing font color of textbox text..... | Excel Programming | |||
| Changing text to numberformat via textbox on a form | Excel Programming | |||
| changing a text value to a number value in a textbox? | Excel Programming | |||
![Ozgur Pars[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
