kruzin24
Last Activity: Jan 10 '07, 07:20 PM
Joined: Jan 6 '07
Location:
-
Killer, thanks for the input on the [ C O D E ] tags, and for assisting with my sort macro. I tried the modified version, and it did not work. However, I tried solomonp's version, and that did work. Seems the key my recorder was using was not correct. Thank you both so much for your assistance with this, I greatly appreciate it! -
Forgive me for the wording on my original question, when I quoted Result of Sort, I meant that this was the result I was looking for. When I run the sort, it actually does nothing. The data looks exactly the way it did before I ran it. I'm going to attempt your modified version, and I will let you know of the result as soon as possible. Thanks again!Leave a comment:
-
I've tried changing the Range("D4") to about everything I could imagine, from the range of the cells to be edited, to the cell which is the header row, with no avail. I appreciate you taking the time to assist with this!Leave a comment:
-
Need help with sort macro.
I have a worksheet that I run a list of macros from, and a sheet called Orders.xls that is edited by the worksheet. It has 4 columns, and a maximum of 3000 rows. I recorded a macro to sort the invoices by column D, by product number. This macro does not error, but does not sort any data. An example of what it sorts is below, also with the macro I am trying.
Data needing sorted:
PRODUCT PRODUCT PRODUCT PRODUCT
... -
I have the popup boxes requesting input now, thank you! Where do I specify the cell to enter the data into? I'm putting the macro on a different sheet other than the one where this macro will be ran. The worksheet that will be edited is called orders.xls. Thanks again!!Leave a comment:
-
Input by popup?
I'm trying to make a textbox pop up that requests that you put in information, and then that information is put into a specified cell. Data would exist in the cell, and the text put into the textbox would have to overwrite a specific area in that cell. An example is below.
PHOTOS ORDERED: 12 PHOTOS RECEIVED: 8
This would all be in one cell. The words PHOTOS ORDERED: and PHOTOS RECEIVED: would need to remain,...
No activity results to display
Leave a comment: