Heyas all,
I'm entering data from textboxes on my form into excel using:
Sheet1.Cells(2, 1).End(xlDown).Offset(1, 0) = UserForm1.textbox1.value
What I need is for the data to entered in a specific order, first by the date field descending then alphabetical by the name field. So it might...
ok I've narrowed the problem down to it being Ends(xlDown)
everything works fine even if I do Sheet1.Cells(2,1).Offset(1,0) and soon as I throw Ends(xlDown) in before Offset, I get "Object doesn't support this property or method"
I'm almost positive it's going to be on the left side, since I don't know what the xldown value should be. And that was a typo, I actually have Cells(2, 1)
Ok, I do sheet1.Cells(2, 0) When hit '.' I don't get the Methods list, so I assume it can't take a method, I enter the whole line and it fails. What does the xldown represent?
Great! thanks for the info. I think I may have worded my question wrong though. I need for the information to be entered into the next "available" cell in the column. Is this possible?
Heyas all,
I'm completely new to the Visual Basic scene, however I do have extensive experience in programm C/C++/ and I'm ok with C#.
My question is, How would I go about taking data entered into a form I made from the textbox and inserting it into a specified cell?
Any information would...
how can I update a dateTime on a Oracle DATE column?
I tryed a lot of different methods, including embedding SQL92 syntax, but I can never seem to do it.
How should I do through JDBC?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.