-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
textbox7.value
-
A
Textbox blank if zero
If TextBox7.Value = 0 Then TextBox7.Value = "" Hello, I have plenty of textboxes on my userform. If the textbox value is zero I want to make it zero as in sample above. Is it possible to make it with a code for all the textboxes? Thanks.- asyamonique
- Thread
- code make sample textbox textbox7.value
- Replies: 5
- Forum: Excel Questions
-
Y
Switch To Uppercase before Inserting Into Table
Hi, I have created a userform with text fields, and it dumps this data into a table. Is it possible to convert everything to UpperCase before the data gets transferred over? Private Sub ENTER_Click() If TextBox1.Value = "" Or TextBox4.Value = "" Or TextBox5.Value = "" Or TextBox6.Value =...- Yuriy B
- Thread
- end table_object.range1 textbox7.value textbox8.value uppercase
- Replies: 1
- Forum: Excel Questions
-
O
Can this be written more elegant / efficent?
Hi I have the following code which works fine but im wondering if there is a more efficient way to write it? Private WithEvents App As Word.Application Public Sub LiklihoodCombos(pcb1 As ComboBox) With pcb1 .Value = "Select." If .ListIndex = -1 Then .AddItem "Select."...- omnivl
- Thread
- case end textbox10.value textbox13.value textbox7.value
- Replies: 0
- Forum: Excel Questions
