Search results

Hi jindon, In run time gets an error '438' Object doesn't support this property or method txt = Application.Replace(txt, m.firstindex + 1, _ m.Length, Format$(m.Value, String(10, "0"))) I have checked the code over and over to make sure that nothing is mistype! If you could...

Got you, Now I click for the first time what you try to given me. Thx again.

a(i, UBound(a, 2)) = GetSortVal(UCase$(txt)): txt = vbNullString Next Hi jindon, I have tried your code, although the data entered into the txtBoxes and listBox are written to the lastRow on spreadsheet, the code stops at GetSortVal as it gives me a compile error. "Sub or...

vletm, thx mate, the cake is good!

Hi vletm, if I use the normal excel ribbon and used the sort order tab and set Column B as key1 and Column C as key2 then it works perfectly. It re-order column B into ascending order then column C into ascending order and then Column A, D and E to follow. But:- I re-code the same code into VBA...

I will put this to the test.

Hi jindon, the problem with the an array is that it list the numbers as is within the array in the same order. It's suppose to re-order in ascending order column A based on the ascending order in column B and secondly the ascending order from column C. Column C which consist of letters only to...

Just need a simple call method to sort the numbers in ascending order. ... and I gave it - sort numbers! Excel do not make mistakes ... And you did not read my previous message through!! which however mentioned mixed numbers (Numbers + letters) or (letters + numbers) thou... I'm not an VBA...

Hi vletm, still try to work on your code. Was not working the first time.

vletm and jindon, Today I am going to put both your code to the test and let you no of my finding. Thanks for helping. Regards

Hi jindon, Thx mate, will try it too. Question, for x = the numbering is some text that the customer put into txtBox and very from 1 to 100. But some numbers are attach with letters. So this x = [{"7B";"7A";21;22;23;"18b";"18C";6; 2;1;"7B";"7A";"18A";33;35;"27A";"27B"}], I'll will never now...

Hi vletm, Thx mate, will try the code but sure I'll have tried it before with no luck. Maybe a mistake or bad cake. Just teasing.

Hi vletm, To real programmers this should be easy as eating a cake! It's actually simply, there's a spreedsheet called "house" with column A,B,C,D,E and column B and C will be hiding from client. Then in developer and then Visual Basic tab, viewing the Forms and when clicked on the "house"...

Hi There, VBA Excel Programming problem! I am having an Add Button on a form. When Clicked, two txtBoxes and a listBox values are written onto a spreadsheet into Column A ("Numbers"), Column D("Size") and Column E("Time") as AM/PM. Column A gets any sort off numbers like 1,2,6,7B,7A, 21,22,23...