Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing a text value to a number value in a textbox?
i can send a text value ,but not a number value to my worksheet, here the code
Private Sub TextBox1_change( Set c = Worksheets("Sheet1").Range("a2" c.Value = TextBox help??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing a text value to a number value in a textbox?
Your code works for me. Try with the first line:
Dim c As Range It may help. In any event, it's very bad programming practice not to declare your variables explicitly. -- Vasant "reb" wrote in message ... i can send a text value ,but not a number value to my worksheet, here the code: Private Sub TextBox1_change() Set c = Worksheets("Sheet1").Range("a2") c.Value = TextBox1 help??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing a text value to a number value in a textbox?
tried it ,but it still shows a text,problem is ,it won't add,,shows as a text inpu
Private Sub TextBox1_change( Dim c As Rang Set c = Worksheets("Sheet1").Range("a2" c.Value = TextBox1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing a text value to a number value in a textbox?
Sorry, I don't understand what you mean. Perhaps you have the cell formatted
as Text. -- Vasant "reb" wrote in message ... tried it ,but it still shows a text,problem is ,it won't add,,shows as a text input Private Sub TextBox1_change() Dim c As Range Set c = Worksheets("Sheet1").Range("a2") c.Value = TextBox1 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing a text value to a number value in a textbox?
tried formating cell in excel worksheet as a number ,still ,no help ,i can use an "if "command in vba to change 1 to 0
if checkbox1.value the sheet1.range("a2")= els sheet1.range(A2")= end i but ,i could only get it to work with a checkbox ,and an optionsbutton ,so i'm wondering ,if it is the way a textbox is set up ,and if so ,then i'll need to find a work aroun p. sorry about my programming ,just started reading about it a week ago |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing text to number | Excel Worksheet Functions | |||
Verify Textbox Information is a Number and Not Text | Excel Discussion (Misc queries) | |||
Text Import Wizard - Changing number format | Excel Discussion (Misc queries) | |||
copying a cell and changing the formating from number to text | Excel Discussion (Misc queries) | |||
edit number in cell without it changing to text | Excel Discussion (Misc queries) |