Johan1959
New Member
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, 18B,18C,18A, ......33,35,27A,27B, till last number.
Then I split, “with a split text coding in a Module" the values in column A to Column B (only Numbers) and Column C (only letters) which I hide from the client.
The Problem:-
Now I want to Automatically after CLICKING the ADD BUTTON, sort Column B(Numbers) in ascending order from small to large and Column C(Letters) to follow in ascending order but to KEEP IT'S position or place with their corresponding Number.
And then Lastly to sort Column A, Column D and Column E using the info from columns B:C
The Data in Column A , D and E will be used elsewhere in the program for the customer to see on a Form but in an ASCENDING Order!!
I have had looked to most Forums for this solution but yet to find my degree of problem solving.
Hope someone is able to assist me.
Thx in advance.
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, 18B,18C,18A, ......33,35,27A,27B, till last number.
Then I split, “with a split text coding in a Module" the values in column A to Column B (only Numbers) and Column C (only letters) which I hide from the client.
The Problem:-
Now I want to Automatically after CLICKING the ADD BUTTON, sort Column B(Numbers) in ascending order from small to large and Column C(Letters) to follow in ascending order but to KEEP IT'S position or place with their corresponding Number.
And then Lastly to sort Column A, Column D and Column E using the info from columns B:C
The Data in Column A , D and E will be used elsewhere in the program for the customer to see on a Form but in an ASCENDING Order!!
I have had looked to most Forums for this solution but yet to find my degree of problem solving.
Hope someone is able to assist me.
Thx in advance.