texts or string input..

[Goh]

appXL1.ActiveSheet.Cells(Number, 3).Value = txtQty.Text

the above statement when i key in txtQty.Text as numbers....the spreadsheet could show the numbers however when i key in letters..error: application-defined or object dfined error....why?

[BrianB]

Input to text boxes always comes out as text.

Perhaps you need to be more explicit and inlclude the form, something like:

appXL1.ActiveSheet.Cells(Number, 3).Value = MyUserFormName.txtQty.Text

Perhaps the error is somewhere else in your code. If the above doesn't work, post the whole code. Where are you running it from ?

[Goh]

hi..how do i post a zip file ?to that you can have a look?

[Goh]

i have try the methods by puting frm. in front but still wont work..

[alex_read]

Rather than uploading a zip file, try to post a smaller / cut down portion of your code relavant to the above question.

In response to this one, try leaving out this .value part & seeing if this makes a difference first...

[salvelinus]

Is that cell formatted to Numbers? Maybe there's a type mismatch if you use letters?

[Goh]

i have solve the problem ...its actually yhe logical error..thanks to your reply..